Project Numbering  Resubmittal retain original project number
Hello.
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 PRO20220001, PRO20220002, PRO20220003. The autopopulation of the number works fine. However, we have one or multiple resubmittals for the same project. So PRO20220002 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

You would need to have two more helper columns (both text/number). One would be where you manually enter the duplicate project number. The other would be the following formula:
=IF([Manual Entry Column]@row <> "", [Manual Entry Column]@row, [AutoNumber Column]@row)
This last column will be the one that displays the correct project number on all rows.
Answers

You would need to have two more helper columns (both text/number). One would be where you manually enter the duplicate project number. The other would be the following formula:
=IF([Manual Entry Column]@row <> "", [Manual Entry Column]@row, [AutoNumber Column]@row)
This last column will be the one that displays the correct project number on all rows.
Help Article Resources
Categories
Check out the Formula Handbook template!