Ability for Forms to Add totals within the form
Is there a way to have a form add a total? For example - we are building a form for potential exhibitors to apply to have a space at an event. On top of their booth space fee, they have the option to add on additional items. We would love for a way on the form to show what their total fee (booth space fee + add on's) would be prior to them submitting their "application" / form.
Comments
-
I'm not aware of one, but you could create a workflow for it. I do a similar thing with a time off form I have created. Create the form to capture the figures as well as their email address set as a contact column. They enter all the information to begin the row, have someone enter the figures based on their choices to total (either manual or formula) and create a trigger that sends an approval request back to them with the figures contained in the email using the {{...}} dynamic text features. Then create an automation that follows whatever response you'd like to have based on them approving or declining the cost.
Just an idea, but could work for your purpose.
CB
-
Hi Scott,
A possible workaround would be to use a third party solution like Google Forms, Formstack or similar. Formstack can do it on the form directly, but there are others as well.
Would that work?
Happy New Year!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!