# Formula

✭✭

For some reason, I can not get my Formula to work. See Below

=IF([Check Done when all have fully completed task]@row = 1, "Yes"), IF([Check Done when all have fully completed task]@row= 0, AND(([Due Date]1= TODAY()-7, )) "No")

Thanks for the help

• Overachievers Alumni

Try this:

=IF([Check Done when all have fully completed task]@row = 1, "Yes", IF(AND([Check Done when all have fully completed task]@row = 0, [Due Date]1 = TODAY(-7)), "No"))

You have nothing happening when Check Done is unchecked and due date is any date other than 7 days ago, was that what you intended?

As it is, the formula is blank for those rows:

• ✭✭

Thanks MCorin

This is almost what I want to have happen. In the second part of the formula,(this is a status box) I would like the status to turn red with an exclamation on the ball ("NO") if the check box is not checked and the due date is within 7 days.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!