![]() |
#1
|
|||
|
|||
![]()
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. |
#2
|
||||
|
||||
![]() ![]() Is this what you are after? |
#3
|
||||
|
||||
![]()
I forgot to add the formulas.. so here they are
![]() ![]() |
![]() |
Tags |
formula help, graphical indicators, ms project 2019 |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
MS Project - RAG status formula | imzkhan4 | Project | 0 | 11-13-2018 12:25 PM |
![]() |
seanspotatobusiness | Drawing and Graphics | 1 | 07-28-2018 02:55 PM |
20 day gap indicator | Planner18 | Project | 3 | 03-23-2017 04:09 PM |
Graphical Indicators customisation | Guloluseus | Project | 5 | 03-03-2014 06:06 PM |
![]() |
nawab35 | Project | 6 | 08-04-2011 05:45 AM |