Need a metrics formula to get the percent of how many "yes" in a particular column

Hi 😊

I have multiple sheets and need to do a formula for a metrics sheet to get the % reviewed on time. I was going to do it like excel but there is constantly rows added to the sheets ( this is dummy data below).

I can't figure out how to get what percentage are "yes". Thank you

image.png


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!