Pre-Filled Form URLs

Hi SS Community,

I created a formula that builds the URL below to pre-fill fields on a form using values from a table. The resulting string works when I copy & paste it into a browser window, but not when I click on the link in the Smartsheet table, the last field (Personal Email) is blank. Does this mean that there is an error in the formula?


=SUBSTITUTE(("" + [Full Name]@row + "&Application ID=" + [Application ID]@row + "&Work Email=" + [Work Email]@row + "&Personal Email=" + [Personal Email]@row), " ", "%20")

FORMULA RESULT:[email protected]&Personal%[email protected]

Screenshot: Copy & Paste URL

Screenshot: Click URL in SS Table

Best Answer