How to make a default multiple selection

[#1]

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.

[#2]

Try the below

Action select field multiple values- YTD

[Gysbert_Wassenaar · Accepted solution]

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.