I have this working with one condition.
=countif(DESCENDANTS(page), x => x."f1" = "Product")
But I’d like to do it with two fields rather than just 1.
=countifs(DESCENDANTS(page), x => x."f1" = "Product" AND x."f2" = "TeamA")
Answer
How do I do a countif with two conditions?
+3Best answer by Jonathan M102
I found my solution I’ll leave the post incase anyone else needs it.
=countif(DESCENDANTS(page), AND(x => x."f1" = "Product", x => x."f2" = "TeamA"))
+3I found my solution I’ll leave the post incase anyone else needs it.
=countif(DESCENDANTS(page), AND(x => x."f1" = "Product", x => x."f2" = "TeamA"))
Jonathan
Create an account in the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in to the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in with Lucid
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
