<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.
We have a document that we would like to use if/then statement to show an image depending on whether or not a criteria is met. So if the criteria is met we would like to show yes/no with a circle around yes and if the criteria is not met i would l...
I am attempting to add a decimal place into the parenthetical text in the comprehensive financial statement. It appears correct for anything that isn't a zero, where it just leaves the value blank (see column A below). Any suggestions on how to fi...
Is it possible to have the hyperlinking functionality in Spreadsheets to function similar to Documents, where it's possible to link to a specific section? Currently, I believe you can only link to a web address, which works initially, but now that...
Excel has the =filter function which allows you to filter a range or an array. You can use it to return multiple rows based on a value or values. For example, from your current sheet you could return all rows from a connected sheet where "FY2020"...
In the NexGen editor, is there a way to insert multiple rows in a table after the initial table is inserted? The standard table comes with 10 rows, but there are times I would need 35+ rows. (For example, building out a compensation table in the ...
Is there any timeline on when the Find & Replace All feature will be available in Workiva spreadsheets? Currently the only option is to find and replace, and this has resulted in our team having to manually find and replace for several thousands o...
Is there a way to be able to spellcheck in the spreadsheets? We are being asked this all the time by our auditors. Is this being considered on the horizon?
Hi, It is possible to attache the picture in spreadsheet in workiva file that this stay open every time like in excel version? thks
Hello - is there any way to lock the column widths in Next Gen spreadsheets as well as tables in Next Gen documents? Users are changing them on us and we do not want that.
One of my biggest Pet Peeve's working is when you are copying+pasting in Spreadsheets it also copies the format related to the cell outlines. We have specific outlines for some of the tables we use and it is very frustrating that is does this when...
In NextGen, is there a way to change the font style in all the sheets of a Spreadsheet at the same time instead of going sheet by sheet (much like applying a font style change to an entire Document instead of going section by section)? When we upl...
We are having to spend a lot of time reapplying formatting after performing excel sync in next gen. This is because if a portion of the text within a single cell in a Wdesk spreadsheet is formatted as superscript (and other text in the same cell i...
The following feature enhancement was suggested by a fellow Workiva customer. If you too would like this feature, vote it up or let us know in a comment below and we’ll get your feedback connected to our Product Team as well. I would love to s...
Be able to simply copy (CTR-C) and paste (CTR-V) a screenshot in spreadsheets (similar to the capability in presentations) for support backup purposes. The current way of attaching a screenshot has too many steps and you can't easily visually...
I am unable to paste long text into spreadsheet cells and table cells in documents. To work around this, I have to take the text, open MS Excel, paste the text in the cell, select all the content in that cell, Ctrl+c, then paste it into the wdesk ...
When multiple users are in a spreadsheet to make updates at the same time, users are encountering issues when trying to make edits when one user has the file filtered. Is there a way that multiple users can sort the same file at the same time and ...
Is it possible to insert an editable graph into Workiva spreadsheets?
Hello - I used Wdesk Sync to sync the data from external source into the workbook, which went well. However, when I then tried to link such data to other sections within the workbook, it did not happen. Can you please advise if it could be beca...
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?
