"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
Comments
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives