Run formula on creation only
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.
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!