The Average Number of Monthly Projects


I want to be able to have a formula that pulls the average number of projects we complete monthly for our sheet summary. I have a date column for "Date Completed". Can anyone help with what the formula would look like?

Best Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    If there is a cell within the range that does not have a date in it such as a blank cell or text, then there will be no data for the YEAR or MONTH function which will throw an error. So we use an IFERROR to turn that error into a zero which obviously does not equal 1 or 2020 or whatever other year or month number you are searching for. This allows the formula to continue running and ensures non-date values within the range will not skew the incoming data.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!