Automatically generated number

Hello,

I am trying to build on Smartsheet a column that print a new consecutive number each time a request from a form is received. I want the following property for the numbers:

  • consecutive numbers
  • when 999 is reached, start again from 1
  • when the month changes, start again from 1

I have managed to build the feature with the changing month, but I cant turn it in a column formula because it contains a "cell reference" in the formula and because the formula dont works in the first cell of the column.

My formula in the column "number" is :

=IF([Month letter]@row=[Month letter]1,IF(Number1 < 1000, Number1 + 1, 1),1)

Do someone have an idea ?

Capture.JPG


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!