Welcome!

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.

Find more posts tagged with

Comments

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

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?

Sign in to join the conversation!

Quick Links

Trending discussions

Keep getting Selected data cannot be charted. Please select a new range.
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
Countifs formula to count based on two columns
I have a picture below for an example of this. I want to create a formula to get counts of items in "Column2", but if "Column4" states "change" I want the "Column2" count to not work and instead count what is it "Column3" in that given row. Column4 can also have several different things in it besides "good" that I want it…
Is there an issue with using reports on a dashboard to create a graph?
I've done this a million times - create a report, separated by campus with a total $$. Then add it to a dashboard and make a graph. NOTHING is working right now when I try to do this. I get an error that the data cannot be charted. What the what? Help anyone? Is this a issue since they apparently changed something in the…