Field in form is not auto-populating data, why?
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?
Best Answers
-
How are you auto-populating the form though? Do you have a formula that generates a URL / link?
-
Do you have any SUBSTITUTE functions built in to swap out spaces and special characters from the various fields?
Answers
-
Can you post the formula? The URL part can be excluded if needed.
-
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.
-
How are you auto-populating the form though? Do you have a formula that generates a URL / link?
-
yes,
=IF(Column 1 <> "", "Form link?Column2=" + Column 2 + "&Field%20Name=" + Column 3 + so on…)
-
Do you have any SUBSTITUTE functions built in to swap out spaces and special characters from the various fields?
-
Well, you pointed me in the right direction. The URL formula was incorrect. Fixed it. Everything works as expected. Thank you.
