How to Calculate Date Specific Average?

I'll be updating data once a month and want to get the average of that data. Currently I'm using =SUM(CHILDREN()) / 12 but that messes up the average because it's dividing January's data by twelve. It should be sum of the children / 2 months (for the average as of February), and then sum of the children / 3 months (for the average as of March), and so on. I'm hoping that I don't need to manually update the formula monthly because it applies to a ton of parent rows!

Appreciate any help!!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!