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.

SUMIFS formula

nrburnand16061
nrburnand16061 ✭
edited 12/09/19 in Archived 2017 Posts

I'm trying to create a formula that adds my second and third column if the fourth column says "LOST" , I want that same formula to subtract the second column from the first column if the fourth column says "KEPT".

-My column titles are:

Column1: total budget

Column2: money allocated

Column3: tentative remaining

Column4: account status

Column5: amount remaining

I've been fooling around with different formulas for a while and I can't get anything to work. any suggestions?

 

2017-06-01 13_34_04-Greenshot.jpg

· Share on FacebookShare on Twitter

Comments

  • Ian
    Ian ✭

    =IF([Account Status]1 = "LOST", [Money Allocated]1 + [Tentative Remaining]1, IF([Account Status]1 = "KEPT", [Money Allocated]1 - [Total Budget]1, 0))

    This formula is only looking for LOST or KEPT, if those are not in [Account Status] it will return 0

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories