Project RAG

Cheryl C

Hi

I have a column formula that works out the project health RAG based on how complete the project is and how the actual end date is tracking against the actual end date (see screen shot below). Some of my RAGs are now blank but, I don't want to tweak the formula in case I mess up the other project RAGs, any ideas how I can show the correct RAG against every project?

Gillian C

Hi @Cheryl C

It looks like there are gaps in your conditions within the formula which is why you are getting blanks, because those conditions haven't been defined. .

e.g the row blank row above the two greens in the screenshot above shows:

• The Red condition is looking for % complete <80 which it is but the number of days is >90 so this row doesn't fit the red criteria
• At 47% it doesn't fit into the yellow criteria of >=50 and < =79
• And the row fits into the Green % complete but the not for the Helper Target Date limits.

My suggestion would be that you check the different possibilities you have for your data and then make sure they are covered by the RAG?

Hope that gives you a starting point for troubleshooting.