0
In excel I can make multiple views of the same workbook/spreadsheet and easily link between one window to the other. In Wdesk next gen I can open two different spreadsheets and have them next to each other, but I can't see how to open two tabs of ...
0
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
We have transitioned several files into Next Gen which have blank cells with the accounting data type. The transition added zero to previously blank accounting cells which messed with some formulas in the same document. How can I transition these ...
0
Is there a way to check down adds (instead of using a calculator to ensure there are no hidden rows in the column you are adding) so you can tie to the total displayed? Same would go for cross adds.
1
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
How can I see the value formats without having to constantly click on it when I go to a new cell. I want the value of the text displayed on the top legend so that I can see if it's thousands or ones or accounting or text. Currently, I click on a c...
2
I used to be able to use Alt + ` and toggle between the overlays in spreadsheets. This shortcut isn't working for me anymore and is not included in the updated shortcut listing. Was this removed? If so, why? This functionality was very helpful in ...
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
Is the Spreadsheet in Next Gen more synchronized to the workbook? In other words, when fixing formatting in the spreadsheet does it fix on the workbook and vice versa?
2
Are there limitations others have experienced and that users should be aware of in terms of maximum # of users at any given time and length of workbook and impact on performance?
0
Does Next Gen provide automatic cell/row height functionality in Spreadsheets?
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
We rolled forward for Q3 and the sheets we had connected in that project are no longer connected. Is there a way to keep sheets connected when rolling forward? Is there a way to delete Sheet Data from the prior quarter? I tried to save the new dat...
0
0
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
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
回答済み
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