AVG, COLLECT, & TODAY combination

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!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!