Sheet Summary formula to count task health that is red

Hannah Gray

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!

Peggy Parchert

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