Formula needed to show project week
Hi all,
I'm trying to put a project week column in my timeline, and I need it to return the actual project week and not the calendar week when looking at the start to finish date.
Example:
If my project started on 31/10 this will be week 1.
The formula looks at the task start and finish date and returns - 1,2,3. This is because the task is from 31/10 to 18/11.
Thanks in advance,
Jez
Answers
-
We can get it to display the start and finish week numbers, but not the numbers in between.
Basically you would take the number of days between the start of the task and the start of the project, divide that by seven, and then ROUNDUP to get the starting week number. You would do the same with the end date of the task to get the ending week number.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives