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")
Solved
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"))
Create an account in the community
A Lucid or airfocus 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 18. You will be redirected to the Lucid or airfocus app to log in.
Log in to the community
A Lucid or airfocus 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 18. You will be redirected to the Lucid or airfocus app to log in.
Log in with Lucid Log in with airfocus
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
