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 status column and the Due Date has been exceeded by 3 days. I've had nothing but headaches in 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 situatio! 

Thank You! 

Paul Newcome

Try something like this...

=IF(AND(Status@row <> "Complete", TODAY(-3) >= [Due Date]@row), 1)

Tamiko Smith

Hello Mr. Newcome,

Thank you so much. That did the trick and worked perfectly.

I am grateful.

Paul Newcome

Try something like this...

=IF(AND(Status@row <> "Complete", TODAY(-3) >= [Due Date]@row), 1)

Tamiko Smith

Hello Mr. Newcome,

Thank you so much. That did the trick and worked perfectly.

I am grateful.

Paul Newcome

Happy to help! 👍️