Sheet that allows for project numbering population

KempenUSA
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)

Picture1.png

Comments

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

    Hi,

    Interesting!

    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, andree@getdone.se)

    I hope that helps!

    Have a fantastic day!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    work-bold

     

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

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