Count If a specific department answered "Yes" at least once

Good Morning!

I've created a conflicts of interest survey and I'm looking for a formula to then reflect on my dashboard for reporting.

Can someone please help me identify how i can use a formula to count if someone from a particular department answered "Yes" at least once within 5 questions? My point is to count how many people per specific department have answered yes to at least one conflict within our five questions.

Any help would be so greatly appreciated. thank you!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!