Auto Add a Number After Auto Numbering

killis_ ✭✭
edited 08/04/23 in Formulas and Functions

I have a master sheet which captures data and assigns an auto-number (Incident Number). When a row falls into a certain category (Warranty), it gets copied to a new sheet.

I want to be able to take that unique Incident Number and add to it. This is what I have so far:

It puts a prefix onto the Incident Number, but I also want it to add a letter or number at the end. So it would read W-CIR-00001-A.

Any ideas would be much appreciated.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!