Counting prior month data


I'm trying to report on prior month data points within a Dashboard I created. I've built a metric sheet off a "master" sheet.

I've attached a screen shot of the metric sheet and a screen shot of the master sheet columns.

Here is the formula I've been using to capture metrics - it needs to be changed to capture prior month not current month data.

=COUNTIFS({Sentiment}, "Positive", {Month}, MONTH(TODAY()))

=COUNTIFS({Region}, Metric@row, {Month}, MONTH(TODAY()))

*Range1 and criterion1 change based on the specific data I'm collecting.

The graphs in the dashboard are being fed by the metric sheet.

Any help is greatly appreciated. Thanks!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!