Formulas in Gantt dates columns
Hello everyone
Do you know if there is a way to put formulas in a start or end date column that is used in a Gantt chart ?
The only feature I can use is to link cell from another sheet, but that means I need to link cells for each task in my gantt planning and it will take so much time..
Thank you for your help,
Corentin
Answers
-
Could you let me know what you are trying to achieve please? If you can provide an image, I may be able to help.
Thanks
Purnima
Purnima Gore
Cierr Limited
Your Time is Important, you want to Stay on Track, We can help you use the Right Tools
-
This may also depend on if you are using these date columns in your Project Settings with dependencies enabled and resource management. In this instance, formulas will not be able to be placed in these columns. Please see our Help Center for more detail on areas where formulas are restricted, here.
Cheers!
Genevieve
-
Hello @Purnima Gore and @Genevieve P
Here is my use case :
I would like this start date 15/06/20 used in gantt parameters to be calculated automatically (for example with an INDEX/MATCH that gets a value form another sheet).
I do not have any predecessors for the moment here, so the case is simpler that with dependencies.
Today I can link the cells as you can see, but this means link each date one by one and it can be extremely time-consuming.
Do you have any ideas or suggestions for this specific need ?
Thank you
Corentin
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives