view by work week in card option

Netanel yosef

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.

RossL

@Netanel yosef

You could have a "Current Week" column that is a check box using the formula

=IF(WW@row = Weeknumber(Today()),1,0)

then use a filter to show only rows with "Current Week" Checked

Netanel yosef

@RossL

hi

thanks that is an option but the checkbox can't display by card view

Andrée Starå

Hi @Netanel yosef

You’d add the formula from Ross in a so-called helper column (checkbox) called Current Week and then you’d create a filter called Current Week (Current Week is checked). When you select the filter in the Card View you’ll only see the cards for the current week.

Make sense?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Netanel yosef

Ok its a good solution

but now the card view displyed all WW, some of them empty and some are not

so how can i display only the current WW with days

Andrée Starå

@Netanel yosef

You'd add another criterion to the filter to not include empty days or only the days that have a date.

Netanel yosef

ok its works

thank you all !

@Andrée Starå @RossL

Andrée Starå

@Netanel yosef

Excellent!

You're more than welcome!

Netanel yosef

another issue now...

i try in same sheet to make filted "plan look ahead' its mean that i want to filter all task that will be next week.

the problem is samrtsheet start the week in Monday and in my place we work Sunday to Thursday

so how can i solve it ?

note: the view card displyed task for each day.

Andrée Starå

@Netanel yosef

You would need to define the days that should count. I think I have a formula in the archive. I'll get back to you!

Andrée Starå

@Netanel yosef

This is solved, right?