Formula not working when trying to build metrics sheet with a a multi-select column

Amy Hayden

=COUNTIFS({FA}, HAS(@cell, [Column2]$1, {Test A Range 1}, $[Primary Column]@row))

Courtney S.

Currently the closing parenthesis for the HAS function is right inside the closing parenthesis for the COUNTIFS. So instead of the 2 arguments that HAS should have, it has 4 instead: HAS(@cell, [Column2]$1, {Test A Range 1}, $[Primary Column]@row)

Amy Hayden

How do I fix it? I'm sorry, I'm not following. I removed what I think you're suggestion but didn't work.

=COUNTIFS(FA}, HAS(@cell, [Column2]$1, {Test A Range 1}, $[Primary Column]@row)

Genevieve P.

Hi @Amy Hayden

I've bolded the change that Courtney was suggesting 🙂

=COUNTIFS({FA}, HAS(@cell, [Column2]$1), {Test A Range 1}, $[Primary Column]@row)