4 Replies Latest reply on Apr 23, 2018 4:36 PM by Zied Masmoudi

    Creating a dynamic default value on a date filter

    Zied Masmoudi

      Hi all,

       

      I set up a simple sheet that has a list of transactions and a month + year filters. I would like for my filters to automatically take the current date as the default value, while still being able to manually change the date to look at future or past transaction lists.

       

      I tried setting up a date filter using "Relative Dates" -> and I set up on this month. While this works just fine in terms of showing the current date, the moment I try to look at a different month/year, I get a blank page.

       

      In short, is there a way to set up a date filter that can automatically take today's date unless manually changed?

       

      Thanks in advance!