AVG(COLLECT) Formula with Multiple Criteria, Including Date Range

I'm trying to write an AVG(COLLECT) formula on a separate metrics sheet to calculate the average number of days in a month for all rows with:

Priority = High

Polling Question = Yes

Start Date >=1/1/2024

Closed Date <=1/31/2024

I've tried numerous formulas, the latest of which is =AVG(COLLECT({IRI-NumberOfDays}:{IRI-NumberOfDays}, {IRI-Priority}:{IRI-Priority}, @cell = "High", {IRI-PollingQuestion}:{IRI-PollingQuestion}, @cell = "Yes")), which comes back as UNPARSEABLE.

Thanks for any help.

Lori Flanigan

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!