Creating an At Risk Formula

ppinkerman

Hello Community,

I am trying to create a formula that will create a flag if the tasks are not marked as Completed in the check box column and the Due Date is within the next 3 days. I've made several attempts at using an IF/AND formula, but can't seem to get it to work properly. 

Any assistance you can provide would be greatly appreciated! 

Thank You! 

Paul Newcome

Give this a go...

 

=IF(AND(Complete@row = 0, [Completed By]@row >= TODAY(-3)), 1)

ppinkerman

Hey Paul,

 

You're awesome! I just had to adjust the "greater than" to "less than" and it worked perfectly. Really appreciate the assistance. 

Thank You! 

Paul Newcome

Happy to help. 

Lassu319

I have applied the same type of formula to track At Risk completion of a task on its due date and its working well using the formula:

=IF(AND(Status@row <> "Complete", Finish@row <= TODAY(1)), 1)

I then created a separate column to track At Risk start-up of a task on its due date (status changes from "Not Started" to "In Progress") but this is not working correctly because it will also flag any task that is complete (status is "Complete").

=IF(AND(Status@row <> "In Progress", Start@row <= TODAY(1)), 1)