I would like to have a column that will show a visual alert for a item that is two weeks from finish and less than 50% complete I have written the formula below in Excell but cannot transfer to Project :
=IF(INT(C2-NOW()) <=14,IF(B2<=50,"R",IF(B2>50,IF(B2<76,"Y","G"))),"N A")

I have attached the excell sheet as well

Can this be done?

Attached Files

Status formula.xlsx (12.7 KB, 13 views)