Cross sheet formula - Reporting by week
Is it possible to create data that provides QTY of selections checked per week and record this on a sheet automatically with formula.
So we are managing live installation projects, with a high turnover of projects. Our main sheet is called PROJECT MILESTONES where we track all the live project activity.
Within this sheet I have a column called "SNAGS" which is a red flag check option and a column called "SNAG COMPLETE" which is a tick check option
I want to be able to by WEEK- see how many active red flag SNAGS there has been and how many active SNAGS have been complete.
My thinking is to create another data sheet, which lists the 52 weeks and date periods, which can calculate between X date and Y date how many red flag snags and how many were completed during that week period only
I will then pull this data into a visual dashboard. So by week I can see the trends if numbers are reducing or increasing.
Problem is the rows are archived once the project is finally complete and we are paid, but I would need the data previously collected to remain in place.
Can this be automated or is it purely going to be a manual thing where I count myself each week and type it into the fields?
I hope I've made sense..... Any help appreciated
Help Article Resources
Check out the Formula Handbook template!