Forcing duration and start date to a specific value on Gantt
Dear Community,
Is it possible to set a formula so that the Start Date always equals the End Date and that the Duration is always '0'? We are tracking key milestones and are only provided the End Date. I'd like to reduce the manual entry to automatically make the Start Date match the End Date and ensure that the Duration is set to 0 so that they show up as milestones on our Gantt chart.
Thanks for any advice
Ilene
Comments
-
Hi Ilene,
It sound like you're working with a project sheet (that has dependencies enabled). If so, it's important to know that formulas are not supported in project columns like the Start and Finish date.
Also, milestones only work when dependencies are enabled. If needed, more information on Project Settings can be found in our help article: https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors
I encourage you to submit a Product Enhancement Request to let our Product team know that you'd like to have the ability to do this in Smartsheet.
-
Hi
thank you for your response...I thought it would be a Catch 22 :-)
I will submit a request
thanks!
Ilene
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!