Forms and Auto Calculated Fields

Hello Smartsheet community!

We use a Smartsheet form to submit vendor invoices for approval (and later extraction into QB).

It would be very helpful to have a field in this form that auto-calculates the taxes so a person doing data entry can verify the taxes are correct.

USE CASE:

  1. User enters the total value of the invoice
  2. Enters tax code (None, GST, GST/PST, Not Simple)
  3. Would be AWESOME to have PST and GST fields on that form that shows what the tax calculation WOULD be given what has been entered/selected.

Is there any way to do this? Please help!

Thanks,

Erik

PS. Our system does a terrible job of handling edge cases, but kicks butt handling 90-95% of invoices/receipts we receive and streamlines the approval and data entry process.

Answers