Can you use formulas in filters?
I am attempting to create a report that pulls from 11 sheets that are being manually updated weekly. I want the report to only show the most current week results from the 11 sheets. I am struggling to find a way for the report to always be pulling the most up to date information but I can only seem to enter a single value in the filter currently.
So my question is two parts
1. can you use a formula in the filter so i am not manually changing the filter each week?
2. if yes, what would my formula be? if no, is there a different way to pull the most current week info into the report?
Thanks in advance for the help!
Help Article Resources
Check out the Formula Handbook template!