Formula for unique job number ✭✭
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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!