Formula Help: Count number of time "Yes" occurs in a row?

Kolsz

Hi there! I am trying to write a formula that will count the number of times "Yes" appears across multiple columns in a single row. I am new to SmartSheet and having a hard time writing the formula. Can someone provide some guidance?

Andrée Starå

Hi @Kolsz

I hope you're well and safe!

Try something like this. (update column names to match yours)

=COUNTIFS([Product 1]@row:[Product 6]@row, "Yes")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Kolsz

Thank you for helping! I assume "Product" is the column name here? I have 27 columns that need to be included in the count; do I list each one individually?

=COUNTIFS([PD? 3Mo]@1:[PD? 6Mo]@1:[PD? 9Mo]@1 ...... , "Yes")

Andrée Starå

@Kolsz

Happy to help!

If they are all beside each other, you can add the first and the last, but yes, otherwise, you'd have to structure it differently.

Are they beside each other?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Kolsz

Unfortunately they are not beside each other and due to the structure of the sheet I cannot move them either :(

Kolsz

I was able to use your formula and make it work! Thank you so much for the help! :)

Andrée Starå

@Kolsz

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!