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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!