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...
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.
Hello, I'm looking at ways to improve setup for our documents and spreadsheets. We have 2 separate spreadsheets (Financial Statements and MD&A) linking to the respective documents of the same name. How can we set up a single source spreadsheet and...
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...
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?
CC: Aileen Pilgrim
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)?
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...
Any plans create a feature to upload a trial balance or financial statements to WDesk in order to map internal controls to FSLI's?
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?
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 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...
Is there a way to set up a conditional fomat when the adjacent cell contains a specific value? In my example below I want cell H2 to be highlighted when cell G2 contains an * or any other value that I choose.
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...
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...
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...
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...
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?
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...