Web Forms using Hidden Fields with Formulas

BrentonJohn

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

Travis

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