Run formula on creation only
Options

DBlasdell
ββ
Hello,
I am trying to have a formula in my primary column to have a date-number of tickets created on this day. so I would have 11/02/21-1 in row 1, 11/02/21-2 in row 2 and so on. However, when A cell is added above it it the formula updates so 11/02/21-1 becomes 11/02/21-2. IS there a way to lock the formula to only run onetime on row creation? Below is my formula.
=[Date Logged]@row + "-" + COUNTIF([Date Logged]$1:[Date Logged]@row, =[Date Logged]@row)
Thanks,
Douglas
Tags:
Answers
-
I found a workaround using Auto number.
-
Douglas - I'm trying to do the same thing. Would you mind sharing how you did it with Auto Number?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!