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

Options

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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!