<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.
Hi, I Imported an Excel file (.xlsx) into a Wdesk Spreadsheet with cells linked to other files saved in my local PC. Workiva shows the imported cells with #SHEET in spite of keeping the link to my locally saved files. Is there any other way to kee...
Is there a support page that provides a legend of all spreadsheet cell indicators in a single place? Folks that don't use Wdesk often can easily forget what certain visual indicators mean. It would be great to have one place to go when you forget ...
I imported a spreadsheet into Wdesk and it has SUM(SUMIFS) formulas all over the place, but I can't seem to get them to work in spreadsheets. So currently I have #VALUE in all the cells. Does anyone know if Wdesk supports the use of this formula...
When preparing financials, we do not want the decimals displayed so we format the numbers to not show the decimals. When using a simple SUM formula, this does not take the decimals in consideration when they are not visible. Example: You have 14,1...
Hello, Is there a way to show the leading zero in a table? I'm trying to display "0408" but it keeps returning "408" even when I use excel files tricks it doesn't work. Thanks.
I have an excel sheet that I would like to copy from on a monthly basis as value into a worksheet. It only copies as values and formulas.
I am trying to create some data checks in a spreadsheet to automate our document cross-reference checks. I have the source data linked to information throughout our document via references and not source links, but when I try to apply conditional ...
We would like to create one combined spreadsheet for our quarterly and year end reporting. What is the best method in Workiva Next Gen to copy portions of our quarterly spreadsheet file to another spreadsheet (e.g. year end spreadsheet)? Thank you.
The following enhancement was shared by a Workiva user: We are really excited for this new formula in Excel and wants to know if we would consider adding it too. https://techcommunity.microsoft.com/t5/Excel-Blog/Announcing-XLOOKUP/ba-p/811376 I...
Can macro enabled excel files be uploaded to Wdesk Spreadsheets?
Is there a way to set up conditional formatting between spreadsheets? Not just within the same spreadsheet?
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...
