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


Reply