<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.
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?
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 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...
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...
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...
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...
In our Proxy, I would like to link a statement that says, "...See "Directions to the 2019 Annual Meeting of Stockholders" on page 64 of this Proxy Statement."I've tried several different approaches to retain the quotes before "Directions" and afte...
Is there a way to add colors to the custom format in the Alternate Row Fill option? I would like to add a lighter gray than is currently offered.
Spreadsheets - exporting to EXCEL
I know that there is an application icon which marks the cell with an orange triangle if the number has changed; however, when there are large spreadsheets with a lot of data, it is difficult to scan the spreadsheets for these orange triangles. I...
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...
I am working in a spreadsheet and I am attempting to connect it to a data set and both the Connect and Data Set are grayed out. Is there a reason for this? I have been able to connect other sheets to Prep with no problems.
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...
I am trying to back into a discount rate that would set a the NPV of a stream = 0. Has anyone had experience with this?
