"Trace Dependents"

tfassnacht
edited 12/09/19 in Smartsheet Basics

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

  • Alejandra
    Alejandra Employee

    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. 

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com