Ability for Forms to Add totals within the form

Scott W
Scott W
edited 12/09/19 in Formulas and Functions

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. 

Tags:

Comments

  • Christopher Brown
    edited 01/03/19

    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

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!