Trying to Average Days based on a Text Field Criteria

o_c

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])

Mark Cronk

Hi @o_c ,

Try

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

Work?

Mark

Mark Cronk

Hi @o_c ,

Try

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

Work?

Mark

o_c

Thanks Mark you rock!!!!