Project Numbering - Resubmittal retain original project number


I am working on a smartsheet that auto generates project numbers for us. Lets say we have Project 1, Project 2, and Project 3. When submitted it creates a project number PRO-2022-0001, PRO-2022-0002, PRO-2022-0003. The autopopulation of the number works fine. However, we have one or multiple resubmittals for the same project. So PRO-2022-0002 may have an initial submittal but then 4 resubmittals for the same project. When these resubmittals come in we want it to maintain the same, initial, project number and not generate a new one.

Please let me know if this is possible and if so, how do we do it? It might be a complex formula or filter function?

Any assistance would be much appreciated!

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!