Average of column if dates meet certain criteria

I'm looking for help on a formula to calculate an average of a column if the date in another column falls between the nominated start and end date. I tried a few different formulas which came up with #UNPARSEABLE, and this one: AVERAGEIF({Date Completed}, AND(>=[Start Date]@row, <=[End Date]@row, {Number})) resulted in zero. Any suggestions on how this formula should read?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!