formulate a reference column that doesn't change if the data referenced changes

How do I formulate a column to reference another cell for value, but not have its value change if the reference cell changes?

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You would need to have a unique identifier on every row. You would then set up a copy row automation to copy the row to another sheet when the data you want to capture is set. Then you would use an INDEX/MATCH to reference the second sheet to bring the static data back in to your working sheet.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!