Skip to main content

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")

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"))


Hi @Jonathan M102 , thanks for contributing to the Lucid for Developers Community and for sharing your solution. Please feel free to reach out if you need further assistance with our formulas or APIs