<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.
Since cells don't have specific values, if a new result is added to the data source, the output ordering will change. If a comment had been left on a cell, it will no longer show up in the initial place. Is there a way to address that?
Would it be possible to consider breaking links and leaving only values (where an error is given in the formula) in the exported file if I select an option to download the file with accurate formulas? I one of our case we have to export excel cal...
I am looking for the ability to sum the absolute values within a range but the functions which allow this in excel do not currently work in Workiva. Is that an alternative which would allow me to sum the absolute values? My example would be if we...
It’s currently very easy to accidentally remove a connection from a spreadsheet section when using the right‑click menu, as Remove connection is located directly below Share updates. There is no warning prompt before the connection is removed. I p...
I have a really simplistic question -- how do I use a linked value from another workbook in a formula? I suppose I could create an intermediary cell in my source or destination workbook, but I'd like to avoid that. Thx
Hello, I require assistance with linking data between two Workiva workbooks. Specifically, I have a data validation rule (dropdown list) implemented in a cell within the workbook named 'A1'. I need to transfer the selected value from this dropdown...
How can we align the column width of Workiva Spreadsheet with Microsoft Excel. MS Excel provide the units "Pixels" whereas Workiva Spreadsheets width its not in pixels
Is it possible to use an 'if' statement to pull back the data from the children tabs if the spreadsheets are not set up exactly the same? I am able to successfully use the CHILDREFS functionality to pull back data from child tabs in spreadsheets...
I am experiencing an issue with time formatting in spreadsheet cells within the platform. Currently, Workiva interprets decimal numbers in base 10, which affects calculations involving hours and minutes. Identified Issue: When I enter values like...
Hello, Is there a way to disable the triangle icon in the corner of formula cells? I have some sheets with large formula-driven tables, and the users find the icons distracting. Thank you! Cedric
We currently leverage connected sheets for reporting and have added additional columns to the report within the module. How can I those columns to the connected report that we leverage? I.e Need the 2 new columns brought into the connected sheet t...
We have all numbers in our ESG Factbook in the fullest precision, but we need to round up or down as needed for our ESG disclosures. I understand how to display the numbers rounded up, but cannot figure out how to get them to display rounded down....
I have created a template in which I have locked certain sections- when I create a spreadsheet from the template none of the locked cells transfer over as "locked". Support told me this is not currently possible & suggested I submit this. thanks
Hi, I'd like to lock certain columns that I have a vlookup formula on, but I don't see a way to do this. In this example I want to lock columns D and F. Anyone know how I can do this? Thanks!
Hello, I am currently working on a project that involves merging information from different CSV files into a spreadsheet. Those CSV files are stored inside a folder in my workspace, next to my spreadsheet. How can I solve this problem? Should I us...
Hi, We are using accounting formatting in spreadsheet, and for a specific report we are looking for a solution to the following display formatting: - If a number is zero => display blank or en dash- If a number is between 0 and 1 => display "0"-...
Hello, Are there plans for the immediate future for a find and replace all function, particularly in spreadsheets?
The following formula works in Excel, but not in Wdesk: =(H5(--('Sheet 1'!E:E="PSU"),--('Sheet 1'!F:F>G6),'Sheet 1'!H:H,'Sheet 1'!I:I))/C34 It's pulling from "Sheet 1" What am I doing wrong?
Is there a way to automatically delete all existing data prior to syncing a worksheet? Each month, I have to sync multiple worksheets to spreadsheets in Wdesk. Some times, the worksheets I have to sync have fewer rows than they had the month befor...
I am looking to create a dashboard to show when all spreadsheet/cell is updated. We have some areas where a spreadsheet is updated manually that feeds into other spreadsheets.
Hi, does anyone know whether we can filter the outline labels in Wdesk Spreadsheet and a summary report of outline labels can be generated?
I need to upload an excel file that is above 40mb. Could you please guide on how to go about it (example, by splitting it & joining all pieces) without losing formula linkages. Please also suggest how to reduce the size of such files.
I have a spreadsheet that will have certain sections that are restricted to some users. I see that there is an option within the filters to 'hide restricted sections' but was wondering if there is an overall setting to hide those sections so that...
Hi, I need to access data from Wdesk to MS power BI report. Can someone guide me how to do that? Thank you.
hi, is there a way to lock the sheet names and sequences? If currently not possible, can we add this as a future enhancement? Most of our chains rely on the sheet names and sequences in copying, pasting or comparing the sheets in workspace to anot...
If I create a new spreadsheet and enter a figure like "8.76%" into a cell, this will be displayed as 9% by default. While that doesn't seem ideal (to me), this isn't my real issue. My question is, when I select the Decimals drop-down where "0" is ...
hi all, I have added a tab from a different workspace as my connection, but how do I know when the tab in the other workspace gets updated and I need to refresh my connection or I will be using stale data? Is there any hlep that can be provided on...
We have a number of reports we are attempting to replicate in Workiva. Within each report, there are 11 tables that describe different information about our tenants and/or units for a property. These tables expand and contract each quarter, and ...
It would be very helpful to have the ability to insert multiple rows in a spreadsheet once we already have information on the spreadsheet. I'm currently working on a project where I need to add a full section of information into the middle of a cu...
Hi is there a way to import excel charts into spreadsheet as chart? Current when doing Workiva sync add-in on excel. It only sync the cell values but not the excel charts. My objective: there are some nicely formatted charts in my excel and I want...
