work week start Monday
i try 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 ?
Best Answer
-
Hi,
The screenshot above shows an additional sheet to be used. In this additional sheet you will need 365 rows for all days of a year and the columns seen in the screenshot.
- in row 1, column "Date": the cell contains a manually entered date and the column type is date
- in row 1, column "Week number": the cell contains the number 1 and the column type is text/number
- in row 1, column "Weekday": the cell contains the formula from the screenshot above and the column type is text/number
- in row 1, column "New week": the cell contains the formula from the screenshot above and the column type is text/number
Your original sheet needs no additional rows or column! But in it's column "current work week" you can use the VLOOKUP formula to get your local week number from the new sheet.
Hope this helps
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
Answers
-
maybe you have othe solution
i have a sheet with tasks fot current week and for next week
and i want to display only the taks for current week Sunday to Thursday in card view
every day in current week i need to see all current week tasks
-
Hi,
in your account settings you can define which days are workdays.
Hope this helps
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
i already set the working day but id i use in formula such as "weeknumber" the answer is not true
its display the same work week for Sumday and Saturday before.
-
Hi,
seen internationally, the week number has an ISO definition (ISO week date - Wikipedia) but also different kind of counting in the world.
Could your target "all tasks that will be next week" be translated to
"all tasks started in the past + not completed OR starting within the next 10 (or other) days" ?
I assume your look ahead should show what's up next and still ongoing during the specified time frame, right?
This would relief you from "next week" as variable.
Your filter in your sheet would look for rows, where
- status is ongoing
- OR
- starting day is within the next 10 days
Hope this helps
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
hi,
the sheet ment for two purposes:
- to display the tasks current week
- display the look ahead tasks for next week.
i want to show it in card view that why i need dropdown for al days (sunday to Saturday ) and every day my employee update the date and i see it every day for each task.
please see the sheet here in link
https://app.smartsheet.com/b/publish?EQBCT=e47aa3db44124285bc34956b7506e218
-
To add to Stefans excellent advice.
You would need to define the specific days that should count. I think I have a formula in the archive. I'll get back to you!
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,
here edit link if somone need...
https://app.smartsheet.com/b/publish?EQBCT=cecedf012cbd4a63bd5a2cd1e7aceccd
-
Hmmm, I hope you don't mind me asking, why you do not use the calendar view ? I ask because I would like to understand what you try to achieve from a business perspective.
You get all the details when double clicking on the task.
Greetings
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
i want to know all tasks, employee and progress every day without clicking.
this sheet show in dashboard in specipic screen in my office
-
Hmm ok, I think you need your own calendar sheet.
In the "Date" column (type date) you just need to enter the first day. "New week" is a checkbox column. And yes, you need 365 rows.
In your existing sheet the helper column "Current work week helper" would have a formula like the following to get the week number belonging to the date in your "Date" column:
=VLOOKUP([Created date]@row, {Date}, 2, false)
{Date} = a cross sheet reference to the newly created sheet, where the complete columns "Date" and "Week number" must be selected.
NOTE: Later changes to the sequence of the columns in the new sheet will damage the cross sheet reference.
Your other helper column can probably be used without modification.
Hope this helps
Stefan
PS: It's maybe a good idea to let Smartsheet know, that the calculation of the week number needs to be adjustable to the setting of your account. I you don't mind use the "Submit Product Enhancement Request" link on this page.
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
PPS: If you use the formulas from my screenshot, replace all the ; with ,
Greetings
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
its make a circular referance in week number column.
its make a problam if i add 365 rows beacuse we work only five days and i dont want see all 7 days.
its seems somting that smartsheet cant support
-
Hi,
The screenshot above shows an additional sheet to be used. In this additional sheet you will need 365 rows for all days of a year and the columns seen in the screenshot.
- in row 1, column "Date": the cell contains a manually entered date and the column type is date
- in row 1, column "Week number": the cell contains the number 1 and the column type is text/number
- in row 1, column "Weekday": the cell contains the formula from the screenshot above and the column type is text/number
- in row 1, column "New week": the cell contains the formula from the screenshot above and the column type is text/number
Your original sheet needs no additional rows or column! But in it's column "current work week" you can use the VLOOKUP formula to get your local week number from the new sheet.
Hope this helps
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
thanks its work i think...
thanks all
-
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
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 33 Webinars
- 7.3K Forum Archives