Formula to pull metrics for previous month

I currently have a formula that pulls metrics into a sheet for a dashboard widget, it currently pulls the data if the month in the month column is the current month. I need it to pull the metrics for the previous month but I can't get it to work. What am I missing? I tried adding a -1 behind the MONTH(TODAY())-1 but that didn't work.


=IFERROR(SUMIFS({NE Peaking OPG.1 Monthly}, {NE Peaking Month} = MONTH(TODAY()), {NE Peaking Year} = YEAR(TODAY())), "0")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!