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!
Help Article Resources
Check out the Formula Handbook template!