How can you control how far back the regulations in your regulation sheet should go? There are two options: you can choose a rolling date range such as 1 month or 6 months or a fixed date range, where you set a start and end date. Let's look at both in more detail.
Rolling Date Range
To change the query in your regulation sheets to this date range, go to the 'Query' tab and look in the 'Filter By' section. If it says Fixed Date Range, then click it and select 'Rolling Date Range' from the drop down menu:
The rolling period defaults to 'All' (so you'll see all the regulations that match your query going back as far as BillTrack50 has records). If you click 'All' you can then choose a different time period from 1 month to 24 months:
Remember to click save when you've chosen the time period and your regulation sheet will then update to just show regulations that have been added in the past X months. As time passes, new regulations will automatically be added and the regulations that fall outside of your chosen time period will drop off.
This way of filtering regulations will probably be the best way to set up your regulations sheets in most cases, so we strongly recommend that you go through all your regulation sheets and check that they are set up with a rolling date range.
Fixed Date Range
If you choose this option, you must enter either both a start and end date or just a start date. If you put both dates, your regulation sheet will not add new proposed regulations introduced after the end date. If you just put a start date, then new proposed regulations will be added, and your regulations sheet will get bigger over time.
This can be useful if you just want to look at regulations during a set period of time (perhaps you want to review environmental regulations proposed in California in 2021 for example). However, for ongoing monitoring of new regulations you may find the rolling date range to be more manageable.
Cover photo by Towfiqu barbhuiya on Unsplash