Need to add an or condition to Count/Collect Formula in Project Metrics Sheet.

Michele L

I need to modify below formula to collect Project ID's on intake sheet where Project Status is "In Progress" or "Not Started". Below works only if Project Status is "In Progress"

=COUNT(DISTINCT(COLLECT({Project ID}, {Project Status}, "In Progress", {Project Length}, Label@row)))

ericncarr

Hi @Michele L you'd basically need to add an OR condition as your criterion using @cell

=COUNT(DISTINCT(COLLECT({Project ID}, {Project Status}, OR(@cell = "In Progress", @cell = "Not Started"), {Project Length}, Label@row)))

ericncarr

Hi @Michele L you'd basically need to add an OR condition as your criterion using @cell

=COUNT(DISTINCT(COLLECT({Project ID}, {Project Status}, OR(@cell = "In Progress", @cell = "Not Started"), {Project Length}, Label@row)))

Michele L

Thank you Eric. This worked great. I thought I trired that before but I must have done something wrong.

😘

ericncarr

You're welcome!