Can someone tell me why this formula doesn't work?

=COUNT(COLLECT({Tasks}, {Status}, [Lookup Value]@row, {Schedule Health}, [Red Light]$1))

The first column works, but the other reference doesn't. TIA


  • Mark Safran
    Mark Safran ✭✭✭✭✭

    @AlexaSno it looks like your criterion for the {Schedule Health} range is just the cell value on Row 1 of the "Red Light" column, which in the screenshot above appears to be blank. So right now the formula is just counting {Tasks} where the {Status} is your Lookup_Value and where the {Schedule Health} is blank.

    Assuming your {Schedule Health} column is Harvey Ball, you can change that criterion to just "Red". so full formula would be: =COUNT(COLLECT({Tasks}, {Status}, [Lookup Value]@row, {Schedule Health}, "Red")). Same then for "Yellow" and "Green"

  • Darla Brown
    Darla Brown Overachievers


    Just for clarification, are you using the same formula in all columns? Or adjusting to match Yellow and Green?


    Darla Brown

    What you meditate on, you empower!

    Overachiever - Core Product Certified - Mobilizer - EAP