<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.
I was writing a SUMIFS formula in my Workiva spreadsheet and I would like to use indentations. I see on this guide (https://support.workiva.com/hc/en-us/articles/360035643052-Use-formulas) [See Advanced Formula Editor] it is possible. Yet, I am no...
I'm noticing that some of my formula cells, which usually have a green triangle in the bottom right to indicate a formula is in use, have turned from green to yellow triangles. Does anyone know why they would have changed to yellow or what the yel...
i believe i found out the issue of importing and Excel workbook into the system. There is an issue that occurs when attempting to reference text in a cell. formula below for reference. =IF(I7="N/A",'Ref_Emissions Factors'!$I$20,XLOOKUP(I7,'Ref_Emi...
Hi, Is there a way to import a file into Workiva as 'values only'? We often have complex formulas in our files or formulas that are pulling from external sources, so when we upload to Workiva we receive '#SHEET' errors in our cells. We were wonde...
In 2022, when Workiva was initially implemented at my company, they were using it as a sharepoint to sign off on completed tasks (not using the tasks feature in Workiva, just using a spreadsheet). They stopped doing this because multiple people we...
Long story short, it looks like when I have a percentage in a table, when it's right aligned, there is an extra space between the last number in the percentage and the percentage sign. Doesn't matter if there are decimal points after or not, that ...
Hi, We are trying to automate some Excel spreadsheet consolidation but found that in Workiva certain Excel functions cannot be processed (e.g. MMULT, TRANSPOSE) and would show #NAME? in the cell. For example this formula: "=MMULT(MMULT(TRANSPOSE...
Even though this functionality currently exists, it forces us to add an inordinate amount of rows and columns of linked information. There has got to be a better way.
I have a workbook butting up against the 2 million cell limit. When I manually review each sheet, I can only account for two-thirds of the cell count (select all, see what the 'count' says in the bottom righthand info pane). Is there anywhere that...
In Excel, a macro could be used to arrange and show/hide our source worksheets for the 10-K or 10-Q, as needed depending on the filing period. It could even rename the worksheets used in both filings to keep the note numbers correct (for example,...
Hello, In our Excel, we have several SUM product formulas with two or more conditions. Although Workiva supports the SUM Product formula, it seems it is not supported when it gets more complicated (2 conditions or more) and it causes errors on the...
Hi, Is it possible to retrieve the Last Update information for a connection? I would like to make a dashboard sheet with the last update for all connections in the sheet. Br Martin UPDATE: I can use ListConnection to get lastRunDate. But it only ...
It would be super helpful to be able to use the split screen option of two sheets within the same document.
This is been an issue for a LONG time, but here it is. When changes are marked in WDesk via tracked changes in a Workbook spreadsheet, we should be able to navigate using the Previous and Next buttons within the Review submenu; however, this hasn'...
I am having an issue having a 0% appear in a spreadsheet. In my linked excel file the 0% appears, but when I sync to Workiva, it does not appear as 0% but blank %. (_%). Is there a way to get the 0% to show for my reporting? Thank you!
Hello, I created a connection from one sheet to another but it keeps failing "error uploading file to spreadsheet" and I don't know what the issue is. It doesn't really tell me the issue is so I could fix it. I have had connecting issue before whi...
I have linked incoming data coming from a sheet in the source Workiva Excel sheet into another Workiva excel sheet. In the receiving Workiva sheet which also includes tables I want to include the mapping in the first column in those tables and se...
Hi! Is there an update on the below? Wondering if Single Cell formatting is still in implementation for Workiva Sync and when the plan for implementation is. https://support.workiva.com/hc/en-us/community/posts/15172118704660-NEW-Workiva-Sync-is-...
When viewing the X-axis and Y-Axis there is valuable information I would like to freeze in both rows and columns. Could we add the ability to freeze both and not one or the other?
hii, I want to round down a particular number and I see we have Mround but it rounds to the nearest multiple, can we also include FLOOR ? so it rounds down to the nearest multiple ?
Added a new report into Workiva with the plans on using the excel sync function to update the report. However, when I open the excel file the Workiva Sync Function is grayed out. Does anyone know why this would be the case?
My workbook contains a pair of worksheets, SheetA and SheetB. SheetA contains formulae that link to SheetB. I would like to duplicate both Sheet A & B to create Sheets C and D), and I would like the formulae to point at the new worksheets (Sheet ...
I notice that there’s no option for the formulas within the spreadsheet to remain without including formulas that link to other spreadsheets on our N-Drive (internal shared drive) – causing errors if we choose the option of keeping all formulas. S...
One of our colleagues is not able to use the Workiva Sync add-in. It states an "ADD-IN ERROR" saying that there is no permission to use the add-in. This person does have access to our Workiva workspace and the old Wdesk Sync worked fine. How can w...
How can I select only certain cells of an Excel sheet if I do not want to sync the entire sheet with Workiva Sync?
Could a UNIQUE or DISTINCT function be added to spreadsheets to determine the unique values from a range of cells?
We are new to Workiva and are setting up our working papers at the moment. I see that there are two options in order to reference data from one spreadsheet section to another section - by formula reference, or by linking. Is there a best practice ...
Hello,Is there a auto-publish functionality in Wdesk? So if I make any changes to the spreadsheet which is linked to the word file, I will have to click on the Publish links button to update the same in the document. Is there a way to auto-publish...
I would really appreciate the functionality of the Excel Indirect function in Spreadsheets. It would allow elements of a function to be variable based on something outside the specific cell with a formula.
