Increment number if same date

Hello. I am using a formula to remove the slashes from a date. I would like to use the resulting value as the row's unique ID, by adding an auto incrementing 2-digit suffix.

Here is the formula:

=YEAR([Date]123) + "" + RIGHT(100 + (MONTH([Date]123)), 2) + "" + RIGHT(100 + (DAY([Date]123)), 2) + "-01"

Which returns something like 20220127-01

Rows are automatically created via Forms. If a row is created on the same day, I want the last two digits to increment by one. Then, back to "01" when a new row is created in a different date.

Is this possible? Thanks for taking a look.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!