AVG, COLLECT, & TODAY combination

howl

Looking to generate the average time (already calculated at row level in sheet) if a date field (completion date) is within the last 7 days of today, to display in a Sheet Summary.

=AVG(COLLECT([Avg Time]:[Avg Time]), [Completion Date]:[Completion Date] >= TODAY(-7))

Incorrect Argument Set 😑

Any help is appreciated!

howl

Figured it out. AVG & COLLECT.

=AVG(COLLECT([Avg Time]:[Avg Time], [Completion Date]:[Completion Date], >=TODAY(-7)))

howl

Figured it out. AVG & COLLECT.

=AVG(COLLECT([Avg Time]:[Avg Time], [Completion Date]:[Completion Date], >=TODAY(-7)))