Schedule Health formula not working,

Finops C'ship

Hi,

Can anyone help me with a formula i have three scenario

.1 & 2. IF start date and end date % complete activity exceed the daily % completion , Status should be In progress and color the schedule health to Green

3 % complete is less than the expected work to be completed within the time frame it should be Red and status should be In progress

Mark Cronk

Good morning,

Try this for your schedule health:

=IF((NETWORKDAY([Start date]@row, today())/NETWORKDAY([start date]@row, [end date]@row))<[% complete]@row, "Red", "Green")

Work?

Mark

Finops C'ship

Hi @Mark Cronk

I think something is not correct on the formula as you could see % complete is more than 50% and start date has not yet came so this should be green not red.

Mark Cronk

What formula are you using in your %complete column that's marking a takes complete when it hasn't started?

Try this to correct you status issue:

=IF(AND(ISDATE([start date]@row), [start date]@row<today()), IF((NETWORKDAY([Start date]@row, today())/NETWORKDAY([start date]@row, [end date]@row))<[% complete]@row, "Red", "Green"))

Getting closer?

Mark