Is there a way to use URL query string to pre-populate a dropdown multi select with more than one value in a form?
Hi @Mathieu Paquin
To populate a Multi-Select dropdown list with multiple values using the query string, you'll just need to add an & and list the field again with the second value, like so:
So if I had more than two values, I'd need to list the field each time:
Let me know if this works for you!
Are you not able to do that using the "default value" portion for that field when building the form?
Yes, but not usefull in that case because the value will not always be the same.
Understood. In that case please see Genevieve's response above. You can also replace sections with cell references as needed.
="url_string?Multi=" + [First Option]@row + "&Multi=" + [Second Option]@row + "rest_of_url_string.com"
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.