Sheet Summary formula to count task health that is red

Options

Hello! I want to use the sheet summary to count how many of my children rows have a health of red in a given "promo month"

Example:

Count if the Promo month = August 2024 and Health = Red (for the children rows only)

Thank you!

Answers

  • Peggy Parchert
    Peggy Parchert ✭✭✭✭✭✭
    edited 06/12/24
    Options

    Hello @Hannah Gray

    Hope you are well. This will work with a helper column.

    If you add a helper column, call it 'Parent' and make it a checkbox column. Insert this formula in the 'Parent' column: =COUNT(ANCESTORS()) - make it a column formula column.

    In the Sheet Summary field - call it 'Count', enter this formula:

    =COUNTIFS(Parent:Parent, 1, [Promo Month]:[Promo Month], "August 2024", Health:Health, "Red")

    Hope it helps.

    Peggy

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!