<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 tried the method in another post about sizing column in the format row and column size adjuster. When i enter a number to drop the size so my table fits on the screen it will make it super small. For example I have a column width of 50 but i w...
I see in Classic Wdesk spreadsheets you were able to add dates (Along with 'Option List', 'Decimal', 'Whole Number', and 'Text') in data validation but in Next-Gen spreadsheets, you can only add a 'range' or 'list'. I want to know how one might be...
Hi team, As some formulas are not supported in Wdesk spreadsheet so when we import an excel which has used a formula not supported by Wdesk spreadsheet, it shows an error in that cell in which formula is used (like text join etc).. Is there any wo...
Is there a way to either use Data Validation or Conditional Formatting in a spreadsheet to have the end user select a date (like from a calendar)?
hello, I did not find a function similar as the name manager from excel into the spredsheet, does it exist ? Thanks for your answer. Rafael
Hello, Everytime i want to sync my excel workbook i lost the formating of my file, does it possible to sync my excel workbook and keep the formating of my table ? Thanks for your answer Rafael BOUCHETA HOYOS
I'm working in the Next Gen and linking cells between the workbook and document. Every time I copy a cell from the workbook and paste/link it in the document and when I return to the workbook, the workbook view is the top of the page and not in th...
Is there a way in a spreadsheet to use tick marks. For example, arrows, lines, symbols.. When creating a tie-out of a footnote, it would be useful to have the spreadsheet set up with the tick marks for ease of exporting to a PDF. We can change the...
can i create a pivot table using connected sheet. i.e. i open a spreadsheet, connect a wdesk report to the spreadsheet and then can i create a pivot table
Does Workiva support array formulas in the spreadsheets? I uploaded an excel workbook that uses array formulas and I cannot seem to get my formulas to calculate in Workiva.
Is it possible to create and Send for Review on Spreadsheet? Also, create blackline?
In excel I can make multiple views of the same workbook/spreadsheet and easily link between one window to the other. In Wdesk next gen I can open two different spreadsheets and have them next to each other, but I can't see how to open two tabs of ...
Hi, i uploaded the files where i use this formula: =IF(B4=0,0,SUMPRODUCT(--('2017 YTD'!$B$133:$B$1000">="&B1),--('2017 YTD'!$B$133:$B$1000"<="&B2),'2017 YTD'!$E$133:$E$1000)/B4) However, it doesn't work. Does anyone know if this formula supported ...
When using the concatenate formula to combine cell text, is it possible to keep the cells format? For example, when combining the Footnote number and Footnote Description, can you keep the Number as regular font and have the Footnote Description I...
We have transitioned several files into Next Gen which have blank cells with the accounting data type. The transition added zero to previously blank accounting cells which messed with some formulas in the same document. How can I transition these ...
Is there a way to check down adds (instead of using a calculator to ensure there are no hidden rows in the column you are adding) so you can tie to the total displayed? Same would go for cross adds.
I have the following questions: On the topic of updating connections within Spreadsheets, it would be extremely helpful to have the functionality to a) be able to update all connections within all spreadsheets in a folder in Wdesk; and b) be able...
How can I see the value formats without having to constantly click on it when I go to a new cell. I want the value of the text displayed on the top legend so that I can see if it's thousands or ones or accounting or text. Currently, I click on a c...
I used to be able to use Alt + ` and toggle between the overlays in spreadsheets. This shortcut isn't working for me anymore and is not included in the updated shortcut listing. Was this removed? If so, why? This functionality was very helpful in ...
When trying to create a cross sheet formula, I start typing the formula in a cell (say its C5) and when I navigate to another sheet to select that same cell reference of C5 in the other sheet, the cell I am trying to reference is covered by the fo...
Is the Spreadsheet in Next Gen more synchronized to the workbook? In other words, when fixing formatting in the spreadsheet does it fix on the workbook and vice versa?
Are there limitations others have experienced and that users should be aware of in terms of maximum # of users at any given time and length of workbook and impact on performance?
Does Next Gen provide automatic cell/row height functionality in Spreadsheets?
When you have a link, you have the option of clicking the paper clip to direct you back to the source. For a formula, is there a shortcut to accomplish this? In Excel, if you hit "Control + [ " it brings you back to the source of the formula. ...
Would anyone know anyway to do a sum if wild card formula similar to Excel formula below in spreadsheets? =SUMIF(RANGE,("text"&"*"),SUM_RANGE)
Has anyone found a work around for XNPV / XIRR functions? Need to run calculations on even distributions.
Hi, Is there a way to set a default font in Spreadsheets similar to setting the default in Excel (for example, I want my font to default to Times New Roman rather than the Arial that is currently defaulting to. Thanks!
Is there a way to set the margins when converting a spreadsheet to a pdf? I have a spreadsheet that will fit on a letter sized page if I was able to change the margins. It is cutting off the border on the sheet. I has an inch margin all around and...
We rolled forward for Q3 and the sheets we had connected in that project are no longer connected. Is there a way to keep sheets connected when rolling forward? Is there a way to delete Sheet Data from the prior quarter? I tried to save the new dat...
