Is it possible to create and Send for Review on Spreadsheet? Also, create blackline?
6
Hi, i uploaded the files where i use this formula: =IF(B4=0,0,SUMPRODUCT(--('2017 YTD'!$B$133:$B$1000">="&B1),--('2017 YTD'!$B$133:$B$1000"<="&B2),'2017 YTD'!$E$133:$E$1000)/B4) However, it doesn't work. Does anyone know if this formula supported ...
4
When using the concatenate formula to combine cell text, is it possible to keep the cells format? For example, when combining the Footnote number and Footnote Description, can you keep the Number as regular font and have the Footnote Description I...
0
I have the following questions: On the topic of updating connections within Spreadsheets, it would be extremely helpful to have the functionality to a) be able to update all connections within all spreadsheets in a folder in Wdesk; and b) be able...
0
When trying to create a cross sheet formula, I start typing the formula in a cell (say its C5) and when I navigate to another sheet to select that same cell reference of C5 in the other sheet, the cell I am trying to reference is covered by the fo...
0
When you have a link, you have the option of clicking the paper clip to direct you back to the source. For a formula, is there a shortcut to accomplish this? In Excel, if you hit "Control + [ " it brings you back to the source of the formula. ...
0
Sum IF wildcard
已回答
Would anyone know anyway to do a sum if wild card formula similar to Excel formula below in spreadsheets? =SUMIF(RANGE,("text"&"*"),SUM_RANGE)
0
Has anyone found a work around for XNPV / XIRR functions? Need to run calculations on even distributions.
2
Hi, Is there a way to set a default font in Spreadsheets similar to setting the default in Excel (for example, I want my font to default to Times New Roman rather than the Arial that is currently defaulting to. Thanks!
0
Is there a way to set the margins when converting a spreadsheet to a pdf? I have a spreadsheet that will fit on a letter sized page if I was able to change the margins. It is cutting off the border on the sheet. I has an inch margin all around and...
1
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 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
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
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
Spreadsheets - exporting to EXCEL
0
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
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
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 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
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
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
I need to understand how to count cells where multiple values are counted. For example I need to count all cells in a column where the cell contains either "Limited" or "Yes". I can't seem to get the arguments to work correctly. Is there a syntax...
0
Dynamic Tables
已回答
I am in the process of building a dashboard to show the status of our who does what schedule. One of my charts it top 5 people with the most things outstanding. Is there a way this automatically updates? I have filtered a table and linked the top ...
0
I'm working on building spreadsheets for our reporting processes. I am curious what is the preferred or best practice for historical data? Previously in workbook we did Index Match formulas to view the historical data and pull in prior periods bas...
1
why can't we concatenate two cells designated as dates in spreadsheets like workbook? I'm working on transitioning to spreadsheets and the i'm trying to create our dates page. I cannot concatenate two cells so produce the output "September 8, 2018...
1
In Excel, we can use =today() for a cell to display today's date. Is there anything similar available in Speadsheet?
38
I am currently rolling forward an entire project and want to "lock" the prior year spreadsheets. However, when applying permissions to the overall spreadsheet, the new permissions don't "flowthrough" to the current sheet.So, for example. . . even ...
0
When doing our rollforwards we put in XX as placeholders so that it can clearly indicate to readers what is still open. However anywhere that we put XX that there is a formula which is dependent of that amount becomes a #value, there should be a f...
0
We've set up our data collection templates to include all rows/categories in a table that could have values. However, many tables have rows that may be zero on a given quarter. rather than breaking links to the DC templates and deleting the rows...
5
1) Is there a way to turn on smart quotes in spreadsheet? 2) Is there no way to spell check in a spreadsheet? Thanks!
0