Dynamic Date Ranges using Google Sheets

Several clients that I build reporting dashboards in Data Studio that  like to adjust the date range themselves to make data dynamic. This has not been an issue until, for a number of reasons,  I switched from SuperMetrics for Data Studio to SuperMetrics for Google Sheets (that I then pull into Data Studio). Does anyone have a remedy for this?