Creating an At Risk Formula

Tamiko Smith

Hello Community,

I am trying to create a formula that will create a flag if the tasks are not marked as Completed in the column that says complete, and the Due Date has been exceeded by 5 days. I've had headaches trying to figure this out.

I would be very grateful for any assistance you can provide with the IF formula which seems to be the formula to apply in this situation! 

Thank You! 

John Jonassen

Give this a shot:

=IF(Complete@row = 1, 0, IF([Due Date]@row < TODAY(-5), 1, 0))

John Jonassen

Give this a shot:

=IF(Complete@row = 1, 0, IF([Due Date]@row < TODAY(-5), 1, 0))

Tamiko Smith

Thank you very much John. That did it. I really appreciate your help.

John Jonassen

Sure thing, @Tamiko Smith !