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

Candace G
Candace G
edited 09/12/23 in Formulas and Functions

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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!