Counting check boxes in a row if "Yes" is written in a cell in the same row
ICue
✭✭✭
The following formula works for counting my check boxes but I cannot seem to figure out how to write the rest of the formula to only count the check boxes in my row if "Yes" is written in a cell in the same row. Help please!
=COUNTIF([Building Perimeter Verified]@row:[Reminder Email Sent]@row, =1)
Thanks so much!
Tags:
Best Answers

Try using the COUNTIF as the output for an IF statement.
=IF([Column Name]@row = "Yes", COUNTIF([Building Perimeter Verified]@row:[Reminder Email Sent]@row, =1))

Thank you so much, Paul! Exactly what I needed!
Answers

Try using the COUNTIF as the output for an IF statement.
=IF([Column Name]@row = "Yes", COUNTIF([Building Perimeter Verified]@row:[Reminder Email Sent]@row, =1))

Thank you so much, Paul! Exactly what I needed!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!