WBS Overdue status trigger points

Cathy Fraser

Hi, I would like to look at setting up a formula that shows if a WBS status is either overdue (symbol would be ! High) or has say 5 days to go on the WBS and is only sitting at 60% completed (symbol would be - Medium). 

The trigger point would have to be driven off the :Finish" date in the setup screen shot. 

The colums would most likely be hidden, but would be used to trigger reports on the dashboard.

I hope the above makes sense :-)

Regards 

Cathy

 

 

MattH

This is what you asked for:

=IF(AND(Finish1 < TODAY(), Complete1 < 1), "", IF(AND(Finish1 - TODAY() <= 5, Complete1 < 0.6), "Medium", ""))

This has an additional set of logic where if it's supposed to be done within two days, and it's not, the status is set to High. You can continue to do further nesting, like this, to achieve more granular reporting. (Or as granular as you can, with Low Medium High)

=IF(AND(Finish1 < TODAY(), Complete1 < 1), "", IF(AND(Finish1 - TODAY() <= 5, Complete1 < 0.6), "Medium", IF(AND(Finish1 - TODAY() <= 2, Complete1 < 1), "High", "")))