I have a table that changes dynamically based on the week we're on by using

=WEEKNUM(TODAY())

but I want to create a dropdown menu with all the week numbers, so a user can select any week and check the data related to that weeknum. However, I'd like that everytime the sheet opens, it shows as a default, the current weeknum.

CodePudding user response：

You might be able to use a non-script approach if you can adapt the technique outlined in detail at

Reference

• https://developers.google.com/apps-script/reference/spreadsheet/range#setvaluevalue
• https://developers.google.com/apps-script/reference/spreadsheet/data-validation-builder#requirevalueinlistvalues