Sheet that allows for project numbering population

KempenUSA ✭✭✭
edited 12/09/19 in Smartsheet Basics

I have created the attached sheet in excel and would like to replicate/create this functionality on a sheet in smartsheets.

The objective is to create a numbering system that are populated based on 2 objectives:

1. Criteria based

2. Sequential

For the 1st part, the individual will select from several criteria's: Owner, Platform, ATA, Model and Code. based on a list of items and dependent on their selections, the criteria would populate a number. 

for the 2nd part, the sequential portion, this is where the last 3 digits are defined in a sequential increase from the the previously created. (the last 3 digits should perform in an automated format)



  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭



    We would use an auto number helper column in combination with the formulas needed.

    Can you describe your process in more detail and maybe share the excel file? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too,

    I hope that helps!

    Have a fantastic day!


    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD




    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.