Run formula on creation only


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)





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!