Trying to Average Days based on a Text Field Criteria


I am trying to get the average days that a contract took to execute after a specific date, however only for items with the text status of Support, what is the best way to do this in smartsheet?

=AVERAGEIF([Status]:[Status], "Support", [Contract Signed]:[Contract Signed], >DATE(2020, 7, 1), [Contract to GL Days]:[Contract to GL Days])

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!