How to do running count of records in Smartsheet?`

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!