How to put formulas in smartsheet form without it automatically override as text?


When I use an automation workflow from a form question hidden as I have the formula as the default value of that question, how can I get it to work it's formula instead of it overriding as a text? So when I put in the formula in the default value in the form and when after the form has been filled, the formula is exposed in the cell with an apostrophe in front of the equal sign indicating it as text rather than a formula.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!