Formulas in Gantt dates columns

Corentin Dal Farra

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

Purnima Gore

Hi @Corentin Dal Farra

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

Genevieve P.

Hi @Corentin Dal Farra

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

Corentin Dal Farra

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