# Creating an At Risk Formula

Options
edited 12/09/19

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!

Tags:

• ✭✭✭✭✭✭
Options

Give this a go...

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

• Options

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!

• ✭✭✭✭✭✭
Options
• ✭✭
Options

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)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!