Can you add a VAT field in a smartsheet?

I want to add a field that automatically works out the VAT in a seperate field so i can calculate how much VAT we pay on services. Is this possible?

I have tried to add a formula e.g =SUM(amount)*20% and also +=SUM(amount)*0.2

Neither of these work - it just shows an error message.

Find more posts tagged with

Healthcare

Education

Formulas

Services

Marketing

Hi Robyn

You have just not quite got the systax right.

=SUM(Amount19 * 0.2) (19 being the row number on my sheet).

If you get error codes then go to the help page for diagnosis.

Hope that helps?

Richardr

if you are just getting the amount from the one row then you don't need the SUM.

If you want the sum from a group of rows eg 19 to 25 then use sum(amount19:amount25)

If you want the sum of all rows then sum(amount:amount)

And, of course use the multiplier.

Note; with VAT at 20% if your amounts are net of VAT the multiplier is .2

whereas if the amount includes VAT the multiplier is 5/6 or 0.8333