Sum if checkbox is not checked?

Shannon C Connor
Shannon C Connor âś­âś­
edited 03/19/20 in Formulas and Functions

What is the formula if I want to sum only the numbers that don't have a box checked in their row? At the bottom of this screenshot, the $9,000 should return a sum of $6500.

Answers

  • Frank Falco
    Frank Falco âś­âś­âś­âś­âś­âś­

    Put this in the cell where it is $9000 in [Amount]

    =SUMIFS(CHILDREN(), CHILDREN([Milestone Paid]@row), 0)


    ✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!