Is it possible to hide dates in a project plan and display week 1, week 2, etc.?

Candace G

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!

Ipshita

Hello @Candace G here are a few helpful links to get your formula right -

WEEKNUMBER Function | Smartsheet Learning Center

https://help.smartsheet.com/function/weeknumber

Returns a number representing the week of the year, 1–53, where 1 is the first week in the year.

NETDAYS Function | Smartsheet Learning Center

https://help.smartsheet.com/function/netdays

Returns the number of days from a start date to an end date

https://app.smartsheet.com/b/publish?EQBCT=32f8257f5d1948bfa948da170231a0c5&_ga=2.230817247.1977660836.1694492588-555952476.1690288183&_gl=1*qi2bff*_ga*NTU1OTUyNDc2LjE2OTAyODgxODM.*_ga_ZYH7XNXMZK*MTY5NDQ5MjU4OS45LjEuMTY5NDQ5MjcyMS40My4wLjA.

Hope this helps!

Cheers,

Ipshita

Candace G

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!

Nick Korna

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! 🙂