Auto-populate a form field with the result of a formula in the sheet.

Shane Brown

I have my sheet set up so that when I click the generated URL, certain fields of the form that the URL leads to are auto-populated with values from the same row. My issue is that it seems like I can only auto-populate manually entered values and not values generated from column formulas. Is there a way to do this? Maybe I can make a helper column and have the text string of the formula result appear there?

Andrée Starå

Hi @Shane Brown

I hope you're well and safe!

Yes, it's possible. I'll get back to the post with an example.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Shane Brown

Thanks Andrée!

Andrée Starå

@Shane Brown

Here's an advanced example where I used a sheet summary field for the Form Url and a couple of substitutes parts to replace characters.

=[FORM URL]# + SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(ColumnA@row, " ", "%20"), ",", "%2C"), "&", "%26"), "#", "%23")

The formula above would output something similar to this. (dummy link)

https://app.smartsheet.com/b/form/772c5c85543b5158645555594a167sgss1d44rf0cdf?Value=1900%20West%20Company%20LLC%20-%20City

Make sense?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Shane Brown

Thanks for the response, but I'm having trouble understanding how it works. Here's what my sheet looks like:

The 2nd cell is the one I'm having trouble with. It comes from a formula that takes the contents of the 8th cell and puts a "-" between each word so it works as a URL. (The 8th cell also comes from a vlookup formula). The formula I have in the last cell with the link is this:

=IF(SKU@row <> "", ("https://app.smartsheet.com/b/form/cbaa8bb0775146409fd553261060221e?SKU=" + SKU@row + "&Location=" + Location@row + "&Name=" + [URL Name]@row), ("https://app.smartsheet.com/b/form/cbaa8bb0775146409fd553261060221e?SKU=" + SKU@row + "&Location=" + Location@row + "&Name=" + [URL Name]@row))

Should I embed Substitute formula into where I have the [URL Name]@row to turn it into a string of text? The form won't allow me to add the field associated with that column or any column that uses a column formula. See below:

Shane Brown

@Andrée Starå is there a way I can make this work?