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")
How do I do a countif with two conditions?
+3
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"))
Reply
Create an account in the community
A Lucid account is required to interact with the community. You will be redirected to the Lucid app to create an account.
Log in to the community
A Lucid account is required to interact with the community. You will be redirected to the Lucid app to log in.
Login with SSO
Log in with Lucidor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.