Hi All, I have a gallery with multiple questions and each question has a answer ( YES/NO ) when i try to use a IF function it works only on the first question in the gallery not all questions
( i want the text to be 1 if any of the answers is "NO" )
i use the formula in the picture below, Please support
thank you so much it works very well 🙂
Put this code in the Text property of the label.
If(CountIf(Gallery1.AllItems, Toggle1.Value = false) > 0, 1)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."