OVERALL HEALTH SYMBOL FORMULA

RJT

Hello,

Trying to put together overall health symbol that reflect the following:

If no tasks are past due, overall health is green.

If less than 10% of tasks are past due, health status is yellow

If more than 10% of tasks are past due, health status is red

Any assistance on this would be greatly appreciated.

L_123

I flipped the red and yellow

=if(countif([due date]:[due date],<today()) = 0,"Green",if(count([due date]:[due date]) * .1 >countif([due date]:[due date],<today()),"Yellow","Red")

L_123

=if(countif([due date]:[due date],<today()) = 0,"Green",if(count([due date]:[due date]) * .1 >countif([due date]:[due date],<today()),"Red","Yellow")

Or something similar

*untested, might be a typo

RJT

L_123

Seems to trigger if any task is red it turns overall health red. I am trying to get it to where if more than 10% is red then it will turn. So if nothing past due it is green. Less than 10% of tasks past due then yellow. If more than 10% of tasks then it would turn red. I greatly appreciate the help.

L_123

I flipped the red and yellow

=if(countif([due date]:[due date],<today()) = 0,"Green",if(count([due date]:[due date]) * .1 >countif([due date]:[due date],<today()),"Yellow","Red")

RJT

L_123,

That worked..I greatly appreciate the assistance...You are a wizard!!

L_123

np, sorry i mixed up my math the first time.

Glad I could help

RJT

Hello...Still having issues with the overall health formula. I am trying to establish a formula that will do the following:

Overall Health Formula Need:

Green = More than 80% of tasks health are green

Yellow = More than 20% and less than 80% of tasks health are yellow

Red = More than 5% and less than 20% of tasks health are red

Individual Task Health

Green= Task is complete

Yellow= Task is in progress and not past due

Red=Task is in progress and past due or delayed or at risk

Blue= Task is not started

Gray= Task is cancelled

Any assistance is greatly appreciated.