Metric Sheet -Showing Trending

gwen.pino78261 ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I set up a metric sheet that with CountIfs formulas to show Monthly Stats.. I just realized that when I change the reporting period on my source sheet , I will lose the value counted in the previous reporting  period...


Is there a way to lock the data values in the previous reporting periods...




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!