When Pre-populating a form, how to deal with a column with multiple choices?

Justin Mauzy

I just got it to work except for 1 thing. Here is the formula:

="https://app.smartsheet.com/b/form/c8b3ebf47a194cb19d8aa1d220aa42ad?Date=" + Date@row + "&Team=" + Team@row + "&Issue=" + SUBSTITUTE(Issue@row, " ", "%20") + "&Notes=" + SUBSTITUTE(Notes@row, " ", "%20")

One of the columns is a a dropdown with multiple choices.

When the link generates, the form will only show the 1st choice.

Any ideas on how to make the "Issue" field populate all of the choices?

Paul Newcome

You may need to substitute the line break in the formula. Line break is CHAR(10) in Smartsheet. I am not sure exactly what you would need to swap it out with to get the URL to register properly as I can't seem to find my reference table at the moment.