Run reports based off of certain cells without tying it to specific data

Hey all,

So I am trying to pull historical data off of weekly back ups. Specifically I am trying to pull project health (color ball symbols) off the last 8 weeks and display them on a dashboard horizontally broken out by columns of each week. I tried cell linking them to the top 8 rows and it works until a new back up is made and it pushes that linked cell down and doesnt update the new cells. Is there a way to set up formulas to always capture data in a specified time frame? Possibly using the create date of the rule to capture data in the corresponding column and spit it out in another column?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!