Help with easier way to build dashboard for each year


I am building a dashboard that consists of multiple different reports that are all linked to metric sheets. In the formulas of the metric sheets, I have hard coded the year into them but I need to build this dashboard for every year and don't want to have to change the year in every single formula (there are about 5 metric sheets and formula for every month). I want to be able to switch between years easier or just be able to copy all the metric sheets and create the reports easier.

This is one of the metric sheets:

The data for these comes from one large data set in smartsheet. Any advice would be appreciated!!

Best Answers



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!