Run reports based off of certain cells without tying it to specific data
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
Check out the Formula Handbook template!