"Trace Dependents"
Hello Community,
Excel has this "Trace Dependents" function which enables to know if (and where) a cell is refered in another cell formula.
I can see that when a cell is further used in a smartsheet formula, the cell has tiny black/blue arrow.
But I struggle to know the cell dependance.
Any clue ?
THanks
Answers
-
Hi tfassnacht,
When a cell is being referenced in a formula on another sheet you'll see a black outbound arrow. If you select the the hyperlink after "Formula used on", you'll see the cell containing the formula.
When a cell contains a formula that's referencing cells in another sheet, you'll see a blue inbound arrow. To see all of the cells referenced by the formula, you'll want to select the hyperlink after "Edit reference".
If needed, more information on this can be found in our help article: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
Also, when you have a moment, please submit a Product Enhancement Request to let our Product team know that you'd like the ability to trace dependents in Smartsheet.
-
In addition...
Cells that are referenced on the SAME sheet do not have an indicator other than when you are editing the cell containing the formula. Then you will see cells/ranges outlined in the corresponding color as the reference in the formula.
-
Hi, in addition to the above, is there a way to see if a column is used in a report or dashboard by any chance?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives