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.
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!