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

Options
Amy Hayden
edited 04/05/24 in Formulas and Functions

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



Answers

  • Courtney S.
    Courtney S. ✭✭✭✭✭
    Options

    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
    edited 04/05/24
    Options

    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.
    Genevieve P. Employee Admin
    Options

    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)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!