Average

bbloch18
bbloch18 ✭✭✭
edited 12/09/19 in Smartsheet Basics

I have a column " Resolved on Request Date" with a "Yes" or "No"

How can I get a average number of yes replies and an average number of no replies.

I want to be able to create a Dashboard on the information.

THanks,

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Try the following formulas to calculate the average of Yeses 

    =COUNTIF([Resolved on Request Date]:[Resolved on Request Date], "Yes") / COUNT([Resolved on Request Date]:[Resolved on Request Date])

    Try the following to average the No's

    =COUNTIF([Resolved on Request Date]:[Resolved on Request Date], "No") / COUNT([Resolved on Request Date]:[Resolved on Request Date])