Formula to subtract a cell with a Green tick image and show a total remaining

Options

Every time I put a Green tick in the KEY column, I want it to subtract the TERMINAL cell within that row and to update the Remaining Terminals to be built.

For example: I have put a GREEN tick in KEY5

So I want BRANCH2 to display the remaining terminals to be built, which should be 14

Hopefully I made sense :-)


Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi Dean,

    You can use SUMIF to add up all of the values in TERMINALS that have a green tick next to them, then subtract them from the rollout row.

    =Terminals3 - SUMIF(KEY:KEY, "Yes", TERMINALS:TERMINALS)

    I used "Yes" because that was the only green tick I could find in my settings. If your green tick uses a different word, you'll want to replace my "Yes" with that other word.


    Hope this helps!


    Best,

    Heather

Answers

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi Dean,

    You can use SUMIF to add up all of the values in TERMINALS that have a green tick next to them, then subtract them from the rollout row.

    =Terminals3 - SUMIF(KEY:KEY, "Yes", TERMINALS:TERMINALS)

    I used "Yes" because that was the only green tick I could find in my settings. If your green tick uses a different word, you'll want to replace my "Yes" with that other word.


    Hope this helps!


    Best,

    Heather

  • Dean Sadler
    Options

    Hi Heather.

    Superstar. Thanks 😋

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!