Sum if checkbox is not checked?

Options
Shannon C Connor
Shannon C Connor ✭✭
edited 03/19/20 in Formulas and Functions
Fuzz.png

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.

· Share on FacebookShare on Twitter

Answers

  • Frank Falco
    Frank Falco ✭✭✭✭✭✭
    Options

    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!

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!