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.

Comments

  • 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. 

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

    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

     

This discussion has been closed.