How to do running count of records in Smartsheet?`

Yavor Bidzhov

I have a column with Unique identifiers that may repeat several times across the entire dataset. I need to create a running count in a helper column which records the version of this row starting from top to bottom. Rows get added to the bottom of the file so each time a new version of the row gets added it should receive its respective Version number based on the column with unique IDs. Screenshot of desired outcome below

Paul Newcome

You would insert an auto number column (called "Auto" in this example) that has no special formatting.

Then you would use this:

=COUNTIFS(ProjectNo:ProjectNo, @cell = ProjctNo@row, Auto:Auto, @cell<= Auto@row)