Consistent [Column Name] Formula


Is there a way to add like a string "[Column Name]" so whenever I add a new column that has that name the formula stays refrenced to that new column with the same name?

Thank you!

Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓

    Hi @A Rose ,

    Thinking along what @Paul Newcome asked...I may have come up with a solution. What if you kept the [This week] column the same, but inserted a column formula in that column to reference the current week.


    Then you could go in and update the column formula for the [This week] column to [1/14/22]@row for next week, [1/21/22]@row the following week, etc.

    It's still manual, but would save having to update multiple formulas.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!