If Statement for three columns

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.

Find more posts tagged with

Construction

Formulas

Comments

L_123

try isblank(Cause1) instead of Cause1 = ""

Paul Newcome

=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".

Kevin Sitech

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?

Paul Newcome

=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.

Kevin Sitech

That did it!

Thanks Paul.

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…