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

Options
✭✭

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?

• ✭✭✭✭✭✭
edited 02/21/23
Options

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭
Options

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")

• ✭✭✭✭✭✭
Options

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭
Options

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

• ✭✭
Options

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

• ✭✭✭✭✭✭
Options

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!