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
-
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
-
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
-
You'd add another criterion to the filter to not include empty days or only the days that have a date.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
This is solved, right?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives