work week start Monday

Netanel yosef · 07/12/20

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 ?

Stefan · 07/13/20

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

Netanel yosef · 07/12/20

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

Stefan · 07/13/20

Hi,

in your account settings you can define which days are workdays.

Hope this helps

Stefan

Netanel yosef · 07/13/20

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.

Stefan · 07/13/20

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

Netanel yosef · 07/13/20

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

Andrée Starå · 07/13/20

Hi @Netanel yosef

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!

Netanel yosef · 07/13/20

ok,

here edit link if somone need...

https://app.smartsheet.com/b/publish?EQBCT=cecedf012cbd4a63bd5a2cd1e7aceccd

Stefan · 07/13/20

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

Netanel yosef · 07/13/20

i want to know all tasks, employee and progress every day without clicking.

this sheet show in dashboard in specipic screen in my office

Stefan · 07/13/20

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.

Stefan · 07/13/20

PPS: If you use the formulas from my screenshot, replace all the ; with ,

Greetings

Stefan

Netanel yosef · 07/13/20

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

Stefan · 07/13/20

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

Netanel yosef · 07/14/20

thanks its work i think...

thanks all

Andrée Starå · 07/14/20

@Netanel yosef

Excellent!

You're more than welcome!

Glad you got it working!

work week start Monday

Best Answer

Answers

Categories