Field in form is not auto-populating data, why?

neetuchopra05

I have a smartsheet 1 and smartsheet 2. After filling values in smartsheet 1 using a formula, I get an URL for a form (saved in smartsheet 2). This form is auto populated with data from smartsheet 1 for some fields. All the required fields are getting auto-populated except one, let's say, XYZ field. The data type for this field is same in smartsheet and the form.

So, why doesn't it get auto-populated while others are getting it.

I checked other posts in the community but couldn't find a solution. Is there one for this issue?

Paul Newcome

How are you auto-populating the form though? Do you have a formula that generates a URL / link?

Paul Newcome

Do you have any SUBSTITUTE functions built in to swap out spaces and special characters from the various fields?

Paul Newcome

Can you post the formula? The URL part can be excluded if needed.

neetuchopra05

So, in smartsheet 1, primary column is filled manually, say, Column1. Based on column 1 , other columns are filled using IFERROR(Index(range, Match(Column 1, range,0)),"") formula. TODAY() is not used in any formulas in smartsheet 1.

Paul Newcome

How are you auto-populating the form though? Do you have a formula that generates a URL / link?

neetuchopra05

yes,

=IF(Column 1 <> "", "Form link?Column2=" + Column 2 + "&Field%20Name=" + Column 3 + so on…)

Paul Newcome

Do you have any SUBSTITUTE functions built in to swap out spaces and special characters from the various fields?

neetuchopra05

Well, you pointed me in the right direction. The URL formula was incorrect. Fixed it. Everything works as expected. Thank you.

Paul Newcome

Happy to help. 👍️