Webform
I have information populated on a sheet via a webform, and I need a value added in a hidden field so that the one cell is populated with the name of another cell but when the form information is added it adds an apostraphe to the beginning of the formula.....below is exactly what I am getting
this is the formula =[Task Name]$7
this is what is added '=[Task Name]$7
Comments
-
Hi Danfenti,
There currently isn't a way to add a formula to your sheet from a form. Instead, you'll want to add the formula to the sheet directly and ensure that your formula is set up to be autofilled to the rest of your sheet as needed when new form entries enter the sheet.
More on autofill can be found in the help center: https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting