Forms with formulas

Andrew Davidson
edited 12/09/19 in Formulas and Functions

I'd like to include a formula (hidden) in a Form that includes a vlookup to another sheet with known email addresses. This would save the user time on entering their email when completing the form. The email is used to contact them back through the application to avoid sending separate emails. The formula is submitted to the sheet as expected but is always preceeded by a " ' " - see example and form image below:

'=VLOOKUP(Location1, {LU Range 1}, 3, false)




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!