Pre-Populate Form with Entire Field from Sheet

Hello Community,

I am trying to figure out how to pre-populate a form with a multi-word field. I know how to populate the form with a field and can provide part of my formula below, but it only brings in the first word of the field and not the entire thing. Can someone please let me know how to bring in the entire field?

Part of the formula:

+ "&Vendor%20Company=" + [Vendor Company]@row

Any help is appreciated!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!