3 Replies Latest reply on Dec 17, 2016 12:20 PM by Shinichiro Murakami

    gantt chart with multiple dates in same column

    Steve Gesuale



      Looking help with a gantt chart, attached.


      I have workplans (ID field) with “planned” and “actual” dates for five stages. Most of the “actual” dates are blank for now so just dealing with “planned”.


      Since the dates are in one column, I’ve created calcs for the “Planned Preparation date” and the “Planned Completed date” and then a “Total days” calc using DATEDIFF. I think this calc is the weak link since it doesn’t seem to return any results.


      Any advice on fixing this calc? My end goal is a gantt bar with Stage on color showing the five stages of each full workplan in segments.


      Thanks for any help!