Project Numbering - Resubmittal retain original project number

R Scov

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 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!

Paul Newcome

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, [Auto-Number Column]@row)

This last column will be the one that displays the correct project number on all rows.

Paul Newcome

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, [Auto-Number Column]@row)

This last column will be the one that displays the correct project number on all rows.