Seriously?! Can't use a formula derived date in Gantt view?
Always something with Smartsheet as soon as you dig one layer deeper to come up with a solution... so frustrating!
I am referencing this thread: https://community.smartsheet.com/discussion/152/date-calculation/p2 to help with creating an end date using a simple formula run against a start date. Cool, seems simple enough.
However this "End Date" date field CANNOT be used in Gantt view because it is derived from a formula (ie. '=Start@row + 30'
This is absolutely useless and, honestly, moronic. Why is a formula derived date so different than a regular date field?????
-Chris
Comments
-
Hi @h1pst3r88
You can use formulas to create Start and End dates for a Gantt chart as long as Dependencies or Resource Management are not enabled. If you're only using the Project Sheet for a Gantt chart, turn off Dependencies in the Project Setting and then you'll be able to use =Start@row + 30!
However if you are also using Dependencies, then you are correct, formulas cannot be placed in that type of column. This is because the End Date is already being derived from a formula... namely the Start Date + the Duration, or it's based off of the row that it's potentially dependent on.
You can see a list of areas where formula use is restricted in our Help Center, here, or find more information on Start and End dates in Project Settings here.
Cheers!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 215 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!