At Risk Flag & IF Function
I am trying to set an IF function to the At Risk column. I would like it to flag if the end date is within 2days or if the % complete task is less than 80%. Can someone help me set that function up?
This is what I am putting in;
=IF(AND([End Date]3 2>=TODAY() + 1, [% Complete]3 <.8) 1, 0)