How can I set a Row ID column that does not change when you move, add or delete rows


Hi all -

I've been able to create a Row ID column that updates when you add/delete a row fairly well, but when rows are moved around it breaks again.

Current set up:

X: autonumber column

Row ID: =MATCH(X@row, X:X, 0)

This works ok but every time I move rows or make big changes I have to re-set the autonumber (X) column. I just need a column that mimics the row# that smartsheet already provides (1st column before the primary)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!