How to flag AT Risk task

Djay

I have Planned FInish Date (Date field), and Actual Finish (Date field) and  % Complete field, I want to flag the task if it's past due and incomplete.

 

currently I tried :=IF(OR([Plan Finish]@row - DATEONLY([Actual Finish]@row) < 0, [% Complete]@row < 0), 1)

 

but not working as intended.

 

Thanks

DJ

Andrée Starå

Hi DJ,

Try this. (I didn't include the Actual Finish because it's not needed as I see it, let me know if I was mistaken)

=IF(AND([Plan Finish]@row < TODAY(); [%Complete]@row < 1); 1; 0)    

The same version but with the below changes for your and others convenience.  

=IF(AND([Plan Finish]@row < TODAY(), [%Complete]@row < 1), 1, 0)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope this helps you!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Djay

Thanks Andree, i's working.

 

Regards

DJ

Andrée Starå

Great!

Happy to help!

Have a fantastic week!

Best,

Andrée