• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Gantt chart auto update percentage completed


New Member
Hi All,

I am trying to create a Gantt chart that automatically updates the percentage completed by calculating the days gone by.

The problem I am sitting with is that once it has been completed a day, it increases the percentage.


  • Project Progress.xlsx
    24.6 KB · Views: 6
how about

NOT "0" is text and NOT a number so you should use just 0 for a number

rather than a calc for 0 - i have just checked to see if the start date is in the future - so E9>today() to make 0


  • Project Progress - ETAF.xlsx
    24.5 KB · Views: 8