Two sets of generated task numbers based on Prefix

Options

Hello,

I have a sheet that is tracking submitted occurrence reports. I need the numbers to be sequential for two different prefixes OR- and SAFOR-. Example OR-1000, OR-1001, OR-1002 AND SAF-1000, SAF-1001, SAF-1002. I don't think I can do this with an auto-number column, but any suggestions on how to do this?

Thanks,

Ashley

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!