Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

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.


  • Richard Rymill SBP
    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. 


    Hope that helps?


  • 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


This discussion has been closed.