<i class="icon-match-section w-icon w-icon-50 w-icon-twfr-file-sheet-g2 w-icon-color"></i><i class="icon-match-section w-icon w-icon-50 w-icon-twfr-link"></i><br><i>General discussion and Q&A for next generation Spreadsheets, including linking to and from next gen content, Sync for Spreadsheets, formulas, filters, comments, data connections, data validations, conditional formatting, attachments, imports and exports, and general formatting.
When using workbook templates, we are constantly adding to our templates to ensure they are up-to-date. I am wondering if there is any way to run a blackline on templates to show all changes that were made to the old version as proof for an au...
No matter what I do on the cell formatting menu, my selected border colors aren't adapted/recognized. (When I re-enter the cell formatting menu, it's as if I never selected any color but black.) Any assistance would be much appreciated.
Hello - I found where I can upload a PDF document as backup for a number in my CAFR document. How do I attach the PDF as backup to a number in my spreadsheet instead?Thanks,
I am working in a spreadsheet and I am attempting to connect it to a data set and both the Connect and Data Set are grayed out. Is there a reason for this? I have been able to connect other sheets to Prep with no problems.
We are in the process of getting group licences this will allow us to use spreadsheets for data collections. Does anyone have any ideas/suggestions of how to attach a sign off or how to get a sign off in the spreadsheet? Thanks in advance!
Can the print area of a workbook section or spreadsheet be edited with page breaks?When I save the section as a pdf, I want two pages of information instead of the one. The easy solution would be to split the information into two sections. Howev...
I have a Workiva spreadsheet with formulas linked to other worksheets in the same spreadsheet workbook. One of these formulas is an index/match lookup formula inside an "ifna" wrapper. The function works in Workiva, but when I export to Excel and ...
I am trying to back into a discount rate that would set a the NPV of a stream = 0. Has anyone had experience with this?
What is the maximum number of cells that can be contained in a spreadsheet in Wdesk? I seem to remember someone saying it was 2 millions, but I wasn't sure if this was still the case?Are there any plans to increase this number?
Is there a way to assign a cell fill (color) dependent on the data validation selected instead of manually doing a cell fill? For instance, I have a 3 options in my new data validation; "In progress, Not started, and Close" and I want "in progress...
I need to understand how to count cells where multiple values are counted. For example I need to count all cells in a column where the cell contains either "Limited" or "Yes". I can't seem to get the arguments to work correctly. Is there a syntax...
Are we able to merge two cells (concantenate) in our Spreadsheets/reports? It won't allow us to do so.
I am in the process of building a dashboard to show the status of our who does what schedule. One of my charts it top 5 people with the most things outstanding. Is there a way this automatically updates? I have filtered a table and linked the top ...
I have a sheet within a spreadsheet where users receive instructions to complete details in another sheet. It would be great if they could click a link and bring them directly to that sheet.
I'm working on building spreadsheets for our reporting processes. I am curious what is the preferred or best practice for historical data? Previously in workbook we did Index Match formulas to view the historical data and pull in prior periods bas...
why can't we concatenate two cells designated as dates in spreadsheets like workbook? I'm working on transitioning to spreadsheets and the i'm trying to create our dates page. I cannot concatenate two cells so produce the output "September 8, 2018...
I am currently rolling forward an entire project and want to "lock" the prior year spreadsheets. However, when applying permissions to the overall spreadsheet, the new permissions don't "flowthrough" to the current sheet.So, for example. . . even ...
How do others work around the following differences between workbooks and spreadsheets? A couple of examples, In workbooks we were able to use multiple formats within one cell. For example, italicizing part of a sentence; bold a word, superscript...
Will conditional formatting be coming to spreadsheets in the near future? Although available on workbooks, there is a preference to have this work in spreadsheets so that the team can collaborate on one doc.
When doing our rollforwards we put in XX as placeholders so that it can clearly indicate to readers what is still open. However anywhere that we put XX that there is a formula which is dependent of that amount becomes a #value, there should be a f...
We don't see any options other than exporting to excel and formatting the excel file.
We've set up our data collection templates to include all rows/categories in a table that could have values. However, many tables have rows that may be zero on a given quarter. rather than breaking links to the DC templates and deleting the rows...
1) Is there a way to turn on smart quotes in spreadsheet? 2) Is there no way to spell check in a spreadsheet? Thanks!
Is there a centralized listing of formulas to be used with Spreadsheets? If yes, can you please share the attachment or link within Workiva?
I would also love to have the labels in wdesk spreadsheet documents....is that being considered?
Is there a way to freeze the spreadsheet in Workiva? I know that I can go sheet by sheet and change the permissions to "Read-Only", but is there a one-step way to do it so that no one is able to make any changes to the spreadsheet at all?
I'm trying to take a Spreadsheet I use in my quarterly project and put it in my annual project (which isn't rolled forward from a quarter). Is there a way to accomplish this? I've tried exporting to CSV and then importing, and while it does bring ...
