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
Answers
-
Hey @Marianne Mc
Try this
=COUNTIFS({Review on time column of this source sheet}, "Yes")/COUNT({Review on time column of this source sheet})
If this formula is going on a separate metrics sheet, you need to insert cross sheet reference. You cannot simply copy paste this formula directly into your sheet.
Will this work for you?
Kelly
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!