Numbering Duplicates Based on a Date

LindsayD ✭✭
edited 05/22/23 in Formulas and Functions

Please see above a sheet for quote submissions, I want the revision number to automatically number the duplicates of service and contractor based on submission date with the oldest being revision number 1.

Currently the Revision Number formula is:

=IF(ISBLANK([Service + Contractor]@row), "", MATCH([Row ID]@row, COLLECT([Row ID]:[Row ID], [Service + Contractor]:[Service + Contractor], [Service + Contractor]@row), 0))

Where the Row ID is just an auto number column. Currently the revision number works if newer submissions come in at the top of the sheet, but I want a formula to ensure no matter the position on the sheet the revision number will be ordered by date.

Any suggestions would be greatly appreciated, thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!