Custom Auto Numbering Function
Hi! New Smartsheet user here, appreciate any help and guidance. I'm looking to create a formula to build a custom auto-number function. I'm including a screenshot for reference. I'd like to automate the Project ID column. Where the project ID is YEAR - CLIENT - CLIENT PROJECT NUMBER.
Is there a formula out there that would work for this? Thank you very much for taking the time to review.
Help Article Resources
Check out the Formula Handbook template!