<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.
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 ...
