Is there a way to automatically refresh filtered data in a spreadsheet or document? Udzielono odpowiedzi

I have a table of data in a spreadsheet. I want some records to appear in one section of a document and other records to appear in other sections of the document. I accomplished this by linking the entire data table to each section of the document...

Gabe M Community Champion Idea Generator
12 |
5
Restore spreadsheet Udzielono odpowiedzi

After uploading a worksheet from Excel, the Workiva spreadsheet read some cells that did not have values and then overlayed some formulas I had that were only in the Workiva spreadsheet (the excel file is used only as a data input and formulated v...

Isabella Ho Rising Star
3 |
0
Transition cross-sheet Workbook links to cross-sheet Spreadsheet formulas Udzielono odpowiedzi

When transitioning a workbook to a spreadsheet, I am presented with an option to "Transition cross-sheet Workbook links to cross-sheet Spreadsheet formulas." What does this do? I am not 100% confident that I understand the description of this chec...

Chad Zenisek All Star Idea Generator Community Champion
1 |
0
Can page breaks be inserted to workbooks or spreadsheets? Udzielono odpowiedzi

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

Joseph Lopez
14 |
0
Why can't dates concatenate in Spreadsheets like workbook Udzielono odpowiedzi

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

Caroline Hemmer Sand
3 |
1
Is there a way to sum only visible rows? Ukończone

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

Ben Andrews Idea Generator Community Champion
27 |
5