<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.
When I copy content from Workiva spread sheet into Workiva doc file by using control C and control V, the clipboard is not showing, so I cannot select paste as links. Can someone help me out please? Thank you! David
I want to tie out one of our spreadsheet files in Wdesk instead of Excel. Currently, I have to export the spreadsheet from Wdesk to Excel to tie it out. Playing around with the attachment icon, I can create placeholders and upload files to my spre...
Hello, I am looking to solve a consistent issue we have on Workvia where hidden rows are still counted in sum/subtotal formulas. One solution would be for us to use Subtotal 109 excel formula as a check to only calculate visible rows, but Workiva ...
I was working in a Wdesk spreadsheet, and I needed to combine cells that contained text into one cell with a delimiter between the text from each cell. However, some of the cells that I am trying to combine contained repeated text, so I thought i...
Does anyone know if there is anyway to flag a cell if it's value is not zero? we have a checks file and although our team does a good job monitoring the spreadsheet to make sure our differences are zero, we do run the risk of missing one because w...
Hi. I'm a new Workiva user. I was wondering if Workiva supports, 1) vlookups, and 2) filtering. Thank you.
Hi. Say you have an income statement that is calendarized with YTD at far right? What is your best practice tip for updating the YTD column each month? I understand data parameters and have reviewed the Audit Committee Template use of it. But wha...
I have applied a filter to my data, and I am using a =SUBTOTAL(9,...) formula, but all values in the range are included, instead of just the visible values of my filtered data. Is there a better way to do this?
How can I be sure that calculations are processed and completed after a data sheet has been loaded?
Hello, My objective is to apply conditional formatting to due dates in a connected sheet so my team knows which controls are due within the next two weeks. I am struggling to figure out if there is a way to set up a dynamic formula or if my only o...
It is very frustrating to not be able to create a pivot table in wdesk. It takes way to long to use sumifs formulas to get the results that a pivot table would provide. I am trying to keep it all in wdesk for audit/control purposes. Is there any...
Hi Does Workiva has a functionality to evaluate a formula error in spreadsheet just like excel in case to understand which parameter is failing and another thing does Workiva doesn't accept this kind of multiple criteria formula as the same formul...
Hi Team Is it possible to copy the entire excel spreadsheet from Cell A1 and paste into another excel spreadsheet into Wdesk? I do not want to sync the file. I am able to copy and paste few sections at a time from one excel to another excel into W...
How can I add a symbol (e.g., up arrow, down arrow) in a spreadsheet cell that contains an existing formula.
Hi, I recently found out that you could add superscripts to spreadsheets via the Symbol function. I was wondering if the superscripts could be done more easily via a superscript function rather than having to go to symbols. If not, was wondering i...
Hi Team, Is there a way to round off the amount in Wdesk spreadsheet to nearest 5000. The formatting only allows to round off to 1000 (& not 5000) . Also, I tried using the normal excel formula but it doesn't seem to work in Wdesk spreadsheet
When I format a spreadsheet and upload it as testing support in Wdesk the formatting does not stay. For example, I changed the color of the font for the first 5 rows of my spreadsheet to red and bold font and made the columns larger so I could see...
Hi, Currently, when users want to make bulk changes in the platform via search and replace, they have to search the entire range and press "replace" once for each cell to be changed. This functionality is very inefficient, Workiva should have a "r...
Hi, It's been a while since I have used Workiva so hoping someone can help. I am trying to write a formula in a worksheet within DataDestination but that pulls from a source in DataSource. Is that possible?
Hi, I want to link the date and amount in the following cell from our single source file. When I try linking them, they don't appear as destination links. Does Workiva have the capability to link text within a cell without linking the entire cell?
I am currently unable to insert images into the Wdesk version of Excel. Images saved in an Excel document do not upload into the Wdesk version of Excel.
How do the cell limits work in Spreadsheets? I understand that there is a limit of 2,000,000 cells in Spreadsheets but I was wondering what counts as a used cell. Is it 2,000,000 cells containing any data or do empty cells count towards the limit ...
I'm a spreadsheet owner, but I can't delete or move the spreadsheet.
We have several audits in wdesk, each audit has a checks file to make sure numbers that need to tie actually tie. The only risk we run is that if we don't monitor these we can miss when there is an issue. If it was only one or two files we would b...
Hi, I've noticed inconcistent behavior of values in a spreadsheet if the format of the spreadsheet is set as "Entered in Millions" / "Shown in Millions". For example if you enter number 10 it will be shown as 10 (A1), but if you multiply 10 * 1 it...
I uploaded an excel file without pivots or external links, yet it "is available for download only." How can this be fixed so I can upload the file and be able to edit it within Workiva?
We have calculations using figures that show up multiple times at varying scales, so they're entered in the spreadsheet in whole dollars and historically the difference calculations are based on that information, then linked and formatted in docum...
I have a spreadsheet open that has no filters applied, the row count is 2728 rows. Only 702 rows are showing and it says there is 702 rows that match filter. I do not have any filters applied so I do not understand why I cannot see all 2728 items?
This post helps explain how you can use CHILDREFS and TEXTJOIN in formulas for data aggregation. Examples and supplemental information is also provided. A common use of Spreadsheets is to aggregate data across a changing number of sheets. Each ti...
