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

Find more posts tagged with

Accepted answers

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.

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.