Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
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
