AVG(Collect) Formula help with date range

sonam.bang ✭✭
edited 12/09/19 in Formulas and Functions

Is there a way I can give a date range in the formula below so that it averages between dates 8/21/19 - 10/29/19

=AVG(COLLECT({Nexus Dependencies Range 5}, {Nexus Dependencies Range 1}, "The Scrum Lords", {Nexus Dependencies Range 3}, DATE(2019, 10, 29)))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!