Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
* I have a field YEAR_WEEK, which consists of data in the form of YYYY-W## (EX: 2020-W32)
* I am using this field as a filter in a sheet
Requirement: On open this sheet, latest 4 weeks should be selected in the YEAR_WEEK field (sheet trigger)
Ex:2020-W29, 2020-W30, 2020-W31, 2020-W32
Please help me on this
maybe something like this ='('&chr(39)&repalce(weekname(today()),'/','-W')&chr(39)&'|'&chr(39)&repalce(weekname(today()-7),'/','-W')&chr(39)&'|'&chr(39)&repalce(weekname(today()-14),'/','-W')&chr(39)&'|'&chr(39)&repalce(weekname(today()-28),'/','-W')&chr(39)&')'
The other option would be to use the triggers along with actions to accomplish things, see the following Help links:
I believe that should give you another avenue here.
Regards,
Brett
maybe something like this ='('&chr(39)&repalce(weekname(today()),'/','-W')&chr(39)&'|'&chr(39)&repalce(weekname(today()-7),'/','-W')&chr(39)&'|'&chr(39)&repalce(weekname(today()-14),'/','-W')&chr(39)&'|'&chr(39)&repalce(weekname(today()-28),'/','-W')&chr(39)&')'
The other option would be to use the triggers along with actions to accomplish things, see the following Help links:
I believe that should give you another avenue here.
Regards,
Brett