Formula for unique job number

lauren.green
lauren.green ✭✭
edited 09/20/23 in Formulas and Functions

Is there a formula I can use to create a unique job number where the prefix is the last two numbers of the year created (i.e. 23-0001 for 2023 and 24-0001 for when it is 2024)? If preferable, can this be done in a formula rather than needing a column for the date created, auto number etc etc. Thanks!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!