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
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 460 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 461 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
