Is it possible to hide dates in a project plan and display week 1, week 2, etc.?
I'm setting up a project where the start date is still to be determined.
I have been asked to provide a column that has the week a certain activity needs to occur in. For example, instead of kicking off the project on 25/09/2023 the Grid View of the project plan should have a column in it that shows the project kicking off in Week 1.
Later activities should show how many weeks it's been since the start date. For example, if it's a 15 week project, the go-live would be in week 15.
Is there a way to do this through formulas?
Thanks in advance!
Answers
-
Hello @Candace G here are a few helpful links to get your formula right -
Hope this helps!
Cheers,
Ipshita
Ipshita Mukherjee
-
Hi @Ipshita. Thanks for that information. The advice on NETDAYS is almost what I want, but in weeks instead.
I do not need to know what week it is from the start of the year, but from the start date of the project. Both the project week and the actual dates need to be displayed in the project plan.
Are there any other suggestions?
Thanks!
-
Hi @Candace G,
If your activities have dates then you can use either NETDAYS or WEEKNUMBER to do what you're after:
NETDAYS formula:
=IFERROR("Week " + (ROUNDUP(NETDAYS(Start@row, [Activity Date]@row) / 7, 0)), "")
WEEKNUMBER formula:
=IFERROR("Week " + MAX(WEEKNUMBER([Activity Date]@row) - WEEKNUMBER(Start@row) + 1, 1), "")
Which you use will probably down to how you want to count the weeks, as seen in the last line. If projects are all started Monday then this is a non-issue, but otherwise it does make a difference if started later in the week - do you want a week from the start to be 7 days or only the same actual week (Mon-Sun)?
Hope this helps some or gives you some ideas, but if you've any problems/questions then just post! 🙂
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!