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.
Running total in Webform
I'm using an embedded Webform as an order form, where customers can select or unselect multiple services (which each have an associated cost).
Does anyone know how to include a "running total" cost (or at least calculate the total cost and display it) on the actual webform before the customer hits the "order" button?
I've created a "Total cost" column in the actual sheet that automatically calculates the total in the sheet, but in the webform it remains blank (I assume since the calculations aren't performed until the webform is submitted and the values populate the cells).
Ideas?
Comments
-
Hello—
There isn't a way to dynamically display information on a Smartsheet web form as an entrant is filling it out.
You might consider adding a SUM or SUMIF formula to your sheet, then sending the row as an email attachment to the entrant: https://help.smartsheet.com/articles/504773-sending-sheets-rows-via-email
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives