% yes in a single column


Hello ,

I am having glitches in what seems to be a simple formula. I have a column called hand hygiene with either "yes" or "No" as the answers.

How do I calculate the % yes's received

I am trying the below formula but seems not to be working.

=(COUNTIF(Hand Hygiene:Hand Hygiene, "Yes") = 1, 0)

Any help would be grateful

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!