How can I take a concatenated string and feed it into a form as an option?

Can't figure this out.. I have form with 4 fields in it. The user picks drop downs off of each of the 4 questions and saves the form.  In the sheet, I have a 5th column that concatenates all of the 4 fields. (It basically builds a unique name for each of our customer audits) and looks like this..

2019_Jun_Fab5_Skyworks   (year, month, location, customer)..  I need to take this concatenated string and provide it back to the users of the audit.. 

We have 5 separate forms for capturing each step of the audit and it's this unique audit name that is unique and connects the separate forms together...

My current method is that sheets sends an admin an email and the admin then goes in and manually puts the concatenated name in a dropdown in the sheet and then it's available.. I want to eliminate that manual step by having SS's just put this concatenated name right into a drop down list so that admin is out of the loop. 

How can I do this?

3 Screen shots below to show what I'm talking about.. (you need to look at the screen shots in order _1 then _2 and finally _3

-I'm cautiously excited to hear if someone has a solution for this...

-Thanks, Dana

 

 

 

Audit Name Contactenation_3.png

Audit Name Contatenation_2.png

Audit Name Input Form_1.png

Comments

  • Nick Burrus
    Nick Burrus ✭✭✭✭✭✭

    This shouldn't be a form value.

    Basically, when you have a few rows submitted you can make formula in that column you have with the following:

    =[Date]1_Location1_Customer1

    For date you're going t obe limited by the default options in Smartsheet. But someone here might have time to break it down into a formula. 

    St Nicholas Burrus MBA, MAOL, GARA, PMP PhD Doctoral Candidate

    I build Smartsheets for the US Government, State Government, and about a dozen of the US Fortune 100s.

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

    Hi Dana,

    There are third-party integrations that can do this. Is that an option?

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Hi Andree, Yes, this is an option. Are you the 3rd party option?

    -Dana

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

    Haha! No, I'm not the third-party option! wink

    Some solutions can synchronize drop-down values.

    I know of two options that were developed with the help of Smartsheet API, and if you got the resources, you could build your own.

    Look here for more info: https://community.smartsheet.com/discussion/populating-dropdown-list

    Hope that helps!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.