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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!