Use of IF AND OR ISBLANK
I would like to write a statement that writes Pending if true and Complete if false. The criteria for Pending are as follows:
If start date > today, and end date > today or end date is blank (where Start Date and End Date are columns)
Here is the statement I wrote, but I keep getting Incorrect Argument Set.
=IF(AND([Start Date]@row > TODAY(), [End Date]@row > TODAY(), OR(ISBLANK([End Date]@row)), "Pending", "Complete"))
I'm pretty sure 'm not using OR correctly - can someone please help?
I am new to writing embedded statements (self teaching through this forum). Any tips are greatly appreciated!
Thank you!
Best Answers
-
I think you meant to do this:
=IF(OR(ISBLANK([End Date]@row), AND([Start Date]@row > TODAY(), [End Date]@row > TODAY())), "Pending", "Complete")
-
That basically states if the end date is blank, make it say "pending", or if the start date AND the end date are greater than Today, make it say "pending", else make it say "Complete".
Answers
-
I think you meant to do this:
=IF(OR(ISBLANK([End Date]@row), AND([Start Date]@row > TODAY(), [End Date]@row > TODAY())), "Pending", "Complete")
-
That basically states if the end date is blank, make it say "pending", or if the start date AND the end date are greater than Today, make it say "pending", else make it say "Complete".
-
Thank you so much, it worked!
-
Awesome good to hear.
Just know with nested Or/And statements you want to think of whether you want the AND inside the OR, or the other way around.
If you want A and (B or C) That would be IF(AND(A,OR(B,C))
If you want A or (B and C) That would be IF(OR(A,AND(B,C))
Can be a bit confusing but with practice you'll get it.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!