Auto sum for YTD


Hi Team

Can you please help with a formulae wherein on 1st of each month, it can sum on the values for all the previous months. I have the the exact format and month type in the sheet like in the snippet below. I do have 2 helper columns and a Automation to update Today's date and subsequent month based on number.

Can you please suggest a formulae so that on 4/1 it calculates 120 and on 5/1 it calculates 200


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!