How can I calculate the average of the values over a period of time?

Victor.Silva ✭✭
edited 09/28/23 in Formulas and Functions

I have two databases, one with the values and dates, and the second to create a more succinct report with just the average of the values in database 1 for each month of the year, but I can't find a formula to help me with this.  Does anyone have a solution for a similar case? I need the calculated average to be like "Calculate the average of the values if >= 01/Jan and <=01/Feb.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!