# If Statement for three columns

edited 12/09/19

Hi Guys!

I am working on the following Formula:

=IF(AND([Date Completed]1 < (TODAY(-3)), Cause1 = "", Correction1 = ""), "Overdue", "OK")

Goal: If the date in a date column [Date Completed] is more than 3 days ago, and the cells for the next two columns are empty - one or both - I want to remind our technicians to fill them out.

I can't quite seem to get the logic down into the formula.

I have tried inserting a NOT, changing < to >, and alternating the True and False values.

I am new to smart sheets and relatively new to formulas. If you guys could help me out, I would be grateful.

Thanks.

Tags:

## Comments

• ✭✭✭✭✭✭

try isblank(Cause1) instead of Cause1 = ""

• ✭✭✭✭✭✭

=IF(AND([Date Completed]1 < (TODAY(-3)), OR(Cause1 = "", Correction1 = "", AND(Cause1 = "", Correction1 = ""))), "Overdue", "OK")

Give this a try. It says if the date is more than three days old and either Cause or Correction are blank or both are blank, "Overdue".

• That's Awesome Paul!

I just need to get it to ignore the [Date Completed] column when it is blank or just report it as "OK"

What do you think?

• ✭✭✭✭✭✭

=IF(ISBLANK([Date Completed]1), "", IF(AND([Date Completed]1 < (TODAY(-3)), OR(Cause1 = "", Correction1 = "", AND(Cause1 = "", Correction1 = ""))), "Overdue", "OK"))

This should work for you.

• That did it!

Thanks Paul.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!