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
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives