Multi Select HAS Formula

Cheryl C

Hi

I'm trying to get a sheet to count any projects where Finance Teams and / or Finance Systems are required to deliver a project at a particular status for a Portfolio dashboard metric. I'm currently using this formula but, it's not pulling the right info back - I'm getting a zero return when I'm expecting a number.

=COUNTIFS({Project Intake l Portfolio}, [Metric Name]@row, {Project Status}, "New", {Project Intake Specialist Resource}, HAS(@cell, "Finance Teams"), {Project Intake Specialist Resource}, HAS(@cell, "Finance Systems"))

TIA

Cheryl

Mark.poole

the way its currently set up its only pulling if it has both Finance Teams and Finance Systems? Instead try.

=COUNTIFS({Project Intake l Portfolio}, [Metric Name]@row, {Project Status}, "New", {Project Intake Specialist Resource}, OR(HAS(@cell, "Finance Teams"), HAS(@cell, "Finance Systems")))

Cheryl C

Brilliant. Thanks @Mark.poole thats done the trick.

Mark.poole

the way its currently set up its only pulling if it has both Finance Teams and Finance Systems? Instead try.

=COUNTIFS({Project Intake l Portfolio}, [Metric Name]@row, {Project Status}, "New", {Project Intake Specialist Resource}, OR(HAS(@cell, "Finance Teams"), HAS(@cell, "Finance Systems")))

Cheryl C

Brilliant. Thanks @Mark.poole thats done the trick.