View Single Post
 
Old 03-10-2021, 06:50 AM
Quinn87 Quinn87 is offline Windows 7 64bit Office 2019
Novice
 
Join Date: Mar 2021
Posts: 1
Quinn87 is on a distinguished road
Lightbulb Graphical indicator formula for MS Project

Hi everyone. I am trying to create a formula to show my project's status using graphical indicators. I would like to show:

If task is 100% complete = Green
If task is not 100% and is passed the date it was due to finish = Red
If task is due in the next 14 days and is under 80% complete = amber
If task has not started = white

I have tried many examples online but can't seem to get any to work.

Any wizards out there i would really appreciate your help.
Reply With Quote