% yes in a single column

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!