Is there a way to autofill a field in a form with a formula?
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?
Help Article Resources
Check out the Formula Handbook template!