Formula Dates vs Gantt display

Hi all,

I have an issue using function + dates + showing them in a Gantt chart. The scenario is the following:

I have three columns set as type Date: Contractual date, Starting date (of execution) and End date (of execution)
The Contractual date is filled in by a conditional hyperlink to the actual project (something like - if the status of the milestone is Complete then put the date in that cell)
The Starting date is also calculated with a formula. In short it is calculated like - if the Priority = x then Starting date = Contractual date + Y days
End date is following the same logic, depending on certain variables End date = Starting date + Days of execution

Just in cell this works great. However, when I try to visualize it in a Gantt chart, once I select the appropriate columns in the Date Range Display of the chart, all formulas disappear and are replaced just with dates.

Is there any way I can visualize this scenario?

Thanks,

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You would have to turn off the dependency settings.

All comments

Paul Newcome

You would have to turn off the dependency settings.

Mihai Nedelcu

It worked, I can see the Gantt now. I will also look into what does it mean for the whole picture but it worked for this specific point.

Thank you :)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.