Can you add a VAT field in a smartsheet?

Robyn Potter

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.

Richard Rymill SBP

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. 

http://help.smartsheet.com/customer/portal/articles/775363-using-formulas#error

Hope that helps?

Richardr

Anthony Henson

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