Is there a way to autofill a field in a form with a formula?

Chris Downes

I tried using a URL query which would allow the test column (text field) to populate with the value from the Business Owner columns (formula) but this doesn't seem to work. I know that you can't pull in a field into the sheet if it has a formula to trying to create a work around. See URL created below to get the result in the screenshot below where test is auto-populated, however I need it to show the value not just reference the "Business Owner@row" text.

Not sure if this is possible?

https://app.smartsheet.com/b/form/15acdd1eefd44f91b58683d799713bd2?test=Business%20Owner%40row

Thanks!

Paul Newcome

@Chris Downes You would create it as a string.

=SUBSTITUTE("base_url" + [Business Owner]@row, " ", "%20")

Chris Downes

Thanks @Paul Newcome

I'm still a little confused. Where would I put this formula? and how would I get it to populate during the form completion for the end user to see?

Paul Newcome

You would put that in the sheet and send the generated URL to the user.

Chris Downes

Looks like this only works if the data is already entered for the Business Area in an existing row, it does not work live during the form submission process. Ie. The form includes the Business Area field so technically the Business Area hasn't been provided in that row so there is nothing to match the Business Owner to. I'm looking to have this match happen in the form process itself to validate the data being submitted in the form. Any thoughts?

Paul Newcome

Ah. Ok. Unfortunately that isn't possible in Smartsheet. Until the data is submitted and stored in the sheet, there is nothing to match against.

Chris Downes

Got it, thanks for your help!