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


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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!