Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Web Forms using Hidden Fields with Formulas
Options
I currently have a formula on a hidden field on a webform. When that web form is submitted, the formula is imported into the sheet with an apostrophe before the formula which creates an issue of having to manually adjust the formula after each web form submission.
Can this be remedied?
-Brenton
Comments
-
BrentonJohn - formulas are formatted as text (rather than a formula) when they are added to a web form. With our auto-filling function, if you have a formula in the two rows above or below a newly added row (new form entry) then the formula is automatically copied down to the new row. Here is information on this functionality: http://help.smartsheet.com/customer/portal/articles/1641473-auto-filling-formulas-and-formatting
This discussion has been closed.
