0
Conditional Formatting
Answered
Is there a way to set up a conditional fomat when the adjacent cell contains a specific value? In my example below I want cell H2 to be highlighted when cell G2 contains an * or any other value that I choose.
0
I am trying to add a symbol in next-gen spreadsheets, yet it appears that this functionality is missing. Any work around until this is fixed. Also, can I get an update on when this will be available?
0
Hi, is there any way i can make these two lines align to the same indentation. (note: my indentation is 0 in this case)
0
Going to begin using spreadsheets for TB automation and linking directly to balance sheet and P&L in the 10Q/K. What other accounting/financing/reporting functions is everyone using Spreadsheets for?
0
I have a table of data in a spreadsheet. I want some records to appear in one section of a document and other records to appear in other sections of the document. I accomplished this by linking the entire data table to each section of the document...
3
Alternate Custom Colors
Answered
Is it possible to alternate colors in a table via a short cut when the colors are not the standard SEC blue and white?
0
Is there a way to attach your spreadsheet as an attachment? For example often times I do the work in the spreadsheet so that it feeds to the link (similar to a lead sheet) in this scenario the supporting documentation that I have agrees to the wor...
1
In our Proxy, I would like to link a statement that says, "...See "Directions to the 2019 Annual Meeting of Stockholders" on page 64 of this Proxy Statement."I've tried several different approaches to retain the quotes before "Directions" and afte...
0
Number to text
Answered
In spreadsheets, is there a way to convert a number "1" to its text equivalent "one". For example, if cell A1 contains "1", is there a formula in A2 I can put to convert that to "one"? Likewise, "2" would read as "two", "3" as "three" etc. Thanks!
0
Is there a way to add colors to the custom format in the Alternate Row Fill option? I would like to add a lighter gray than is currently offered.
0
How do you export less than the full file from spreadsheets? I only need four of my >25 tabs.
Completed
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
Lock / Unlock Cell Shading
Answered
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
Data load to locked cell
Answered
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
Combining two Spreadsheets into one
Answered
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
Answered
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
Adding between worksheets
Answered
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