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

dana_hood · 07/05/19

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

Nick Burrus · 07/05/19

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å · 07/06/19

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 · 07/10/19

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

-Dana

Andrée Starå · 07/11/19

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!

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

Comments

Help Article Resources

Categories