Sum if checkbox is not checked?

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!