Hi,
I have developed a project plan (which includes a % complete and a % planned column) and I wish to insert 3 types of indicators to show me how I am advancing with the progress of each activity:
Green: Shows the activity is on target
Yellow: Shows that the activity is between 1%-10% behind schedule
Red: Shows that the activity is greater than 10% behind schedule
I know how to insert the indicator but I don't know what formula I can use to calculate if i'm on target or behind schedule. Any ideas?
In case you are wondering, the % complete column I inserted comes by default in project, however, the % planned is a text column which I update by clicking on "upadate project" button on the project tab which automatically updated progress % of each activity. I then copy that information onto the % planned column.
Thanks