I have multiple sheets and on the first sheet- I have added a sheet action- 'Select values in a field' on the sheet properties.
This is the expression I have used on the action =if(getselectedcount(Date)=0,num(WeekStart(today()-7)),Date)
The problem I face with this sheet action is-
1. Whenever I open the sheet for the first time which has the above sheet action that was setup is not working, as it only works when I reload/refresh the page.
2. Once the Action got applied after refreshing the sheet and if I apply filter on any of the other sheets and come back to the first sheet which has the action- the action on the first sheet is not working at this point of time and shows only the filter that was selected on the other sheet. And if I refresh the sheet again, it shows the action and also the filter that was selected on the other sheet
Is there a way to show the sheet action when I open the sheet for the first time instead of refreshing the sheet to show this action?