Looking for Yes and No answer percentages
I have a sheet with 4 columns that are yes and no answers. I am looking to get percentages for each answer in each column. I would also like to put this is a summary field so I can extract it to a dashboard. I'm struggling to find the right formula for this, and was hoping someone could help.
Best Answer

Hi @jmdierking,
I would try this formula in your Sheet Summary to capture the % for Yes:
=COUNTIF([Column1]:[Column1], "Yes") / COUNTIF([Column1]:[Column1], OR(@cell = "Yes", @cell = "No"))
I would use this formula to capture the percentage for No:
=COUNTIF([Column1]:[Column1], "No") / COUNTIF([Column1]:[Column1], OR(@cell = "Yes", @cell = "No"))
After you apply the formulas to your Sheet Summary fields, you will need to change the fields to be formatted as Percentage. To do that, click the 3 dots next to the Summary field name, select "Number Formatting", and then select "Percentage".
Hope this helps!
Ray
Answers

Hi @jmdierking,
I would try this formula in your Sheet Summary to capture the % for Yes:
=COUNTIF([Column1]:[Column1], "Yes") / COUNTIF([Column1]:[Column1], OR(@cell = "Yes", @cell = "No"))
I would use this formula to capture the percentage for No:
=COUNTIF([Column1]:[Column1], "No") / COUNTIF([Column1]:[Column1], OR(@cell = "Yes", @cell = "No"))
After you apply the formulas to your Sheet Summary fields, you will need to change the fields to be formatted as Percentage. To do that, click the 3 dots next to the Summary field name, select "Number Formatting", and then select "Percentage".
Hope this helps!
Ray

My method above will also ignore any blanks because it's strictly looking for Yes or No values.

This was exactly what I was looking to do!! Thank you!!

Awesome, glad it worked! Please remember to smash that Answer button, so others can more easily find solutions like this!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 284 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!