view by work week in card option

Hi,

i have a sheet with my compeny task that update every day by project managers.

each task get the data from the PMs ever the at 08:00 morning.

i want to see all in Card view when the section is WW (work week)

the problem is if i put all number between 1-52 then in Card view i saw all WW numbers even if it is passed.


how can i view the tasks of that week each week ?

any idea?



The source sheet


the view


the view 2...


i want to display only the current WW.

Comments