Increment numbers

Hi,

We try to generate numbers via formula,,, everything works fine except auto increment,,,

=IF(AND(Status@row <> "Forecast"; Status@row <> "Request"); IF(MAX(COLLECT([Help_Offers-/Project-Nr.]:[Help_Offers-/Project-Nr.]; [Help_Project-Nr._Generator]:[Help_Project-Nr._Generator]; =[Help_Project-Nr._Generator]@row)) = 0; [Help_Project-Nr._Generator]@row + "" + "01"; MAX(COLLECT([Help_Offers-/Project-Nr.]:[Help_Offers-/Project-Nr.]; [Help_Project-Nr._Generator]:[Help_Project-Nr._Generator]; =[Help_Project-Nr._Generator]@row)) + 1))


Current Results Expected

10221101 10221101

10221101 10221102

10221101 10221103

can you please help me out,,Thank you

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!