Spreadsheets - exporting to EXCEL
0
I'm trying to debug a formula (cross sheet, same file) that should be returning a date but it keeps giving me "null" in the target cell. Same behavior with =match
-1
We recently changed from Workbooks to Spreadsheets and noticed that we lost the feature where when a cell is locked the shade/transparency of the cell changes so that the user can easily tell visually what cells are locked/unlocked. In Spreadsheet...
0
We have some locked cells in our worksheet that were intentionally locked because we do not want data to load into those cells. However, we had some cells that were mistakenly locked. When the data was updated, those cells did not update because...
-1
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...
0
Hi everyone. I'm trying to remove the trailing space at the end of a linked cell. The source cell does not have any spaces, and the number is pushed far against the right border of the cell. However, when I copy over the link to the new cell, desp...
0
1
I imported two separate spreadsheets into Wdesk and these two spreadsheets are within a Project. Each spreadsheet has multiple tabs within it. What I want to do now is combine these two, so that I am working with just one spreadsheet with multip...
0
Restore spreadsheet
回答済み
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...
0
I made a few changes to a new gen workbook that I do not like. The undo bottom is now greyed out, Control + Z is is also not working. Can I go back to a previous (autosaved) version and delete the current version?
1
I am syncing in a schedule and I want to use the rounding adjustment column, but I have 5 columns that need to be rounded and then crossfoot. Is there a way to do this where I can round columns 1 - 4 and then ensure when they add across they agre...
0
0
Using spreadsheets, is it possible to use a =Sum formula to add across multiple worksheets?
0
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...
0
I am having a problem linking from a spreadsheet to a doc, but I don't think that data limitation is the issue. It seems to be when there is a destination link vs. a source link. For example, I have a table that has a combination of source links a...
0
1
A member of my team recently accidentally deleted a sheet from our Wdesk Spreadsheet. This sheet had the ledger pull information for reporting segments and contributed to about 10% of our 10-Q. All sections of our 10-Q and 8-K where the segment in...
0
Is it possible to insert an image or PDF into the Workiva Spreadsheets?I know it's possible in Documents, but have not been able to do it in Spreadsheets.
0
I searched and couldn't find this answer elsewhere. Having just been migrated to spreadsheets from the classic version, I no longer seem to be able to add remarks when publishing changes as in the past version. We used this feature to loosely tr...
0
When using workbook templates, we are constantly adding to our templates to ensure they are up-to-date. I am wondering if there is any way to run a blackline on templates to show all changes that were made to the old version as proof for an au...
0
0
No matter what I do on the cell formatting menu, my selected border colors aren't adapted/recognized. (When I re-enter the cell formatting menu, it's as if I never selected any color but black.) Any assistance would be much appreciated.
-1
Hello - I found where I can upload a PDF document as backup for a number in my CAFR document. How do I attach the PDF as backup to a number in my spreadsheet instead?Thanks,
0
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.
0
We are in the process of getting group licences this will allow us to use spreadsheets for data collections. Does anyone have any ideas/suggestions of how to attach a sign off or how to get a sign off in the spreadsheet? Thanks in advance!
0
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...
0
I have a Workiva spreadsheet with formulas linked to other worksheets in the same spreadsheet workbook. One of these formulas is an index/match lookup formula inside an "ifna" wrapper. The function works in Workiva, but when I export to Excel and ...
0
Is there a formula to determine the rate at which the NPV would equal 0 of a stream of payments?
回答済み
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?
0
What is the maximum number of cells that can be contained in a spreadsheet in Wdesk? I seem to remember someone saying it was 2 millions, but I wasn't sure if this was still the case?Are there any plans to increase this number?
0
Is there a way to assign a cell fill (color) dependent on the data validation selected instead of manually doing a cell fill? For instance, I have a 3 options in my new data validation; "In progress, Not started, and Close" and I want "in progress...
0