Calculate YTD based on given criteria

Options

Very new to Smartsheet:

I have a sheet with 14 columns. The first 12 are Jan-Dec. The 13th is the Reporting Month thru which I want smartsheet to calculate the YTD total. And the "PTD" column is the formula with the result.

Let's pretend we're in June, and I want to look back at Q1. I want to populate column 13 ("RPTMO" in image below) with the number 3 so smartsheet will add up Jan+Feb+Mar columns and put the result in the "PTD" column. In Excel I would use a helper row and then sumif, but without a helper row I don't know how to accomplish this without 12 embedded IF formulas, which is an ugly solution.

Any help would be appreciated!

Thank you!



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!