How can I present in a gantt chart that the task exceed the due date?

Michal Curtz

How can I present in a gantt chart that the task exceed the due date? for example the due date of a task was 01/09/20 but until now it is still in progress . I want to show that the actual performance exceed the due date, not only that it is 80% complition, since we exceded our planning time.

MCorbin

You could create a "Symbol" column using the Red/Yellow/Green Balls.

Then add the formula:

=IF(AND([Due Date]@row < TODAY(), Status@row <> "Complete"), "Red", "Green")

This will give you a red indicator if the Due date is in the past and the line is not marked complete.

If you wanted text, you could change it to something like:

=IF(AND([Due Date]@row < TODAY(), Status@row <> "Complete"), "Past Due", "On Target")