Project Week Number by project start/end date
I am needing to calculate actual project week number as majority of projects cross multiple years.
The current WeekNumber formula goes by calendar year, therefore resets each January.
Project start - 12/04/2023 / Project end - 03/10/2025
12/04/2023 = week 1
03/10/2025 = week 56
Meg Young
mmyoungconsulting@gmail.com
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
Best Answer
-
In that case you would use something along the lines of
=INT(([Date Column]@row - MIN(COLLECT([Date Column]:[Date Column], [Date Column]:[Date Column], @cell <> ""))) / 7) + 1
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Where would this week number be populated exactly? Are you able to provide screenshots for context?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome It would be populated in the project plan. Right now it is just for one report.
Goal is to show project week number alongside task start date, assigned to, estimated effort, and actual capacity for external clients.
Meg Young
mmyoungconsulting@gmail.com
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks! -
On every row?
Are you concerned with the week numbers following specific days on the calendar (Monday to Sunday type of thing) or would the start of the week be based on the start of the project so that some would be Tuesday through Monday and others could be Friday through Thursday based on the day the project actually starts?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome It would be based on the project start date and not a specific day of week.
Meg Young
mmyoungconsulting@gmail.com
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks! -
In that case you would use something along the lines of
=INT(([Date Column]@row - MIN(COLLECT([Date Column]:[Date Column], [Date Column]:[Date Column], @cell <> ""))) / 7) + 1
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
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
Check out the Formula Handbook template!