Summing fields in a web form

Kathy McFarland

I have built a purchase request form to replace a PDF and allow the users to enter details by department and upload attachments. One thing I would like to be able to do is to have the form sum up while being entered - item price + Tax + shipping + other = Total. Each of these are individual fields in the form that a user fills in. The current PDF macro we are replacing tallies the total based on the entries. It would be nice to be able to have the Smartsheet web form do the same as the user is filling it out.

Is there a way to do this?

Thanks,

Kathy McFarland

Andrée Starå

Hi @Kathy McFarland

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could use a third-party form service/integration.

Is that an option?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Kathy McFarland

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could use a third-party form service/integration.

Is that an option?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Kathy McFarland

@Andrée Starå

Thanks for letting me know that this is not currently a feature. I will be submitting an ER as you suggested.

What third party form service integration would you recommend to be able to do this sort of simple calculation? Any help you can provide would be much appreciated.

Thanks,

Kathy

Andrée Starå

@Kathy McFarland

Excellent!

You're more than welcome!

There are a couple of options.

• 123FormBuilder
• Formstack
• Or many others by using Zapier to connect them to Smartsheet.

Would any of those work?