I want to set a filter of date range of last 7 days from current day by default on opening of app. Bookmark i have tried but i have different date fields used for different sheets and thus one bookmark will not work for all dates. Also if i select last 7 days from date picker and then set bookmark it is fixed for those days only and thus not dynamic.
Is there any extension or something which could help me here. So kind of a global date range default selection i need.