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

dana_hood

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

 

 

 

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. 

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

dana_hood

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

-Dana

Andrée Starå

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

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!