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
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!