There are times that we have a large date for graphs that are not linked into a spreadsheet. Is there a way to export the live chart spreadsheet as excel?
0
hello, I can't figure out why workiva is throwing a #VALUE! error for the following formulas: =IF(ISBLANK($F2),"",INDEX('COA & FSL Mapping'!$B:$B,MATCH($C2&$F2,'COA & FSL Mapping'!$U:$U&'COA & FSL Mapping'!$A:$A,0))) =IF(ISBLANK($F3),"",XLOOKUP(1...
2
Is there a way to limit the characters that can be entered in a cell? I couldn't find anything on it. We have a lot of departments entering their justification for new funding and it's creating a massive report, is there a way for them to limit ...
3
Hello. I’m looking for help on the best option in Wdesk worksheet to return all rows (records) based on criteria defined from one sheet (data source) to new sheet. There are several ways to do this in excel and one option that comes to mind is the...
3
Hi, I'm trying to list down all unique values from a column in a spreadsheet. For eg. If I have the below list in the column in a spreadsheet: A. And I want to transform the column so that only the unique values are shown as below: B. Is there...
5
I am trying to import an .xlsx file and the size is 45,219 KB. It is failing and I am not sure why. Has anyone had success in importing a file this size and if so, what can I do to get this to work? Thanks!
0
0
Is there a way to automatically show users who are actively viewing/editing a spreadsheet or document?
0
If you want, you can apply the criteria to one range and sum the corresponding values in a different range. For example, the formula =SUMIF(B2:B5, "TD", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:...
0
Hello, my team is attempting to align the values within a spreadsheet such that the ones place, hundreds place, etc are vertically in-line (and aligned on the right side of the cells). Given we are using the accounting formatting of the figures, (...
0
I have one document that is in whole dollars and linking it to another document that will be in thousands. During this process, we have come across footing issues. I started using the "round" formula which will allow it foot but came across other ...
0
Hi, below is a screen of the error that appears when importing excel with named references. Is it possible to import such file using Wdesk sync? Thanks, Michał
0
Anyone know if you can use a formula in a workbook to pull in the sheetname? Say the sheet name is "XBRL," I want a formula that will pull in that text to a cell, then change if I change the sheet name to "Mona Lisa." Thanks for any thoughts.
0
It looks like Wdesk Spreadsheet doesn't support RRI or CAGR function. Is Workiva bringing this function? Does anyone know workaround function for this formula? Thanks in advance.
1
One of fellow workspace owners has the Connect button grayed out on a Spreadsheet that he owns. When I made myself an owner, the Connect button is not grayed out for me. What else should I troubleshoot? Thanks!
0
Pivot Table
回答済み
Hi there, Are there any alternatives way that help in the absence of pivot table to present data on workiva spreadsheet? Thanks
1
When formulas which are linked to restricted sheets are edited, they corrupt. Sometimes the formulas need to be adjusted slightly to include say a rounding. When this rounding cell is added to the formula, the result does not display if the team m...
0
I have been unable to utilize the superscript format within a formula. The formula is an if statement that dynamically creates row titles based on the values in other columns (e.g. "realized gains" when all positive amounts vs "realized gains (los...
0
Hi! I want to use a formula connecting two different spreadsheets. Im trying to use VLOOKUP formula, when I try to select for the table array, a table in another file inside workiva, the formula is no longer active and I cant continue typing. Is t...
0
Hi All. My first post in this community. Probably is very easy the answer. Sorry for that. Question 1: Is it possible to chande date in a spreadsheet after the task has been completed by the user? Question 2: Is this is possible, how know the ESG...
1
Hi, I've been trying without luck to use the SUBTOTAL formula to exclude hidden rows as a useful way to check if my total in the tables of the Financial Statements matches with the total in the Primary File, although I got a error message saying t...
1
I was wondering when we could use Percentile and Quartile functions in Spreadsheets? We use this for our CECL calculations and we want it all to be in Wdesk, but cannot do the entire file in Wdesk until these functions are in Wdesk.
2
I recently had to transpose roughly 60 columns x 4 rows into 60 rows x 4 columns. While I was able to do this in Excel, I couldn't copy the links from the source data. Transposing in Wdesk spreadsheet would allow me to retain the links to the sour...
1
Hello everyone, Does anyone know if Workiva supports txt. format files to update spreadsheet content? Or do I have to convert the txt. file into an Excel file before importing it? What is the best practice recommended? My question is concerning bo...
0
I couldn't find any specific resource to aid in troubleshooting Wdesk Sync, so leaving this here as a future reference for the community; hopefully someone will find this helpful. During our organization's adoption of Sync, we encountered a tempor...
2
Hi! We are exploring the possibility of including our 10Q/10K Data Spreadsheet into our certification process so data providers can input and certify the information directly in the system. We will create copies of the tabs so data providers can u...
0
Hello, Is there a way to 'set' certain cells to sync? I know we can do only selected cells, but with a multiple tab document, it can be time consuming to select cells on each tab when wanting to sync multiple tabs. It would be nice if there was ...
0
Hi Team, I would like to know where can i find the attachment id for an attachment in spreadsheet.
0
Is there a way to shade the cell a custom color? We want to use company colors when using alternate shading. It does not appear that the function of 'alternate cell shading' has ability to choose anything other than present combinations. But when ...
0
Does Workiva support calculations with nested formulas, or is it limited to support nested formulas for calculated amounts (e.g. pulling from a cell that is an output of another calculation)?
0