<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...
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'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...
In Excel, we can use =today() for a cell to display today's date. Is there anything similar available in Speadsheet?
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 ...
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'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!
