Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anybody know how to have a dynamic selection onActivateSheet or similar, which selects all weeks from week 1 and until current date. I am doing a cost/budget comparison, and needs to have all pasts weeks selected. I have a field to hold the week number : k_Week.
First, I tried to make a search to establish a bookmark, but I cannot come up with the right expression. Tried expressions like this: "<=week(ReloadTime())", but without luck. Neither I can search with =Week(Today()). This selects all weeks every time.
Create a variable in the script: LET vWeek = week(today());
Then add a Select in Field action to the OnActivateSheet trigger with k_Week as Field and ='<=' & $(vWeek) as search string.
Try the below
Create a variable in the script: LET vWeek = week(today());
Then add a Select in Field action to the OnActivateSheet trigger with k_Week as Field and ='<=' & $(vWeek) as search string.