How can I set a dynamic filter on a report to auto change to today's date?

edited 12/01/21 in Smartsheet Basics

I have created a report to track upcoming go-lives to display on a dashboard, I currently have a filter that specifies an exact date, but is it possible to have a filter that pulls in data for a date 30 days before todays date or even today's date? For example, a condition that will say Original Go-Live is greater than Today's Date or 30 days before Today's date?

If not, are there any alternative ways I could be showing this information dynamically in a dashboard


Best Answer