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

Marianne Mc

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

Kelly Moore

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.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

Will this work for you?

Kelly