IF/AND/OR Statements Help To Check A Box When Criteria Met
Hi,
I am trying to write a formula with multiple IF statements with OR and AND to check the appropriate box:
I have this so far and get #INCORRECT ARGUMENT:
=IF(AND(NOT(ISBLANK([Term Date]@row))), OR(Program@row = "ABC", [Shared Programs]@row, OR(@cell = "ABC / XYZ", @cell = "XYZ / ABC")), 1, 0)
Thanks for any help offered!
Lori
Answers
-
Try this instead:
=IF(AND([Term Date]@row <> "", OR(Program@row = "ABC", CONTAINS("ABC", [Shared Program]@row))), 1)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thanks, Paul! That formula works for the Term columns; however, when I change the <>"" to "" for the Active columns, I get *UNPARSEABLE.
-
Can you provide the formula itself?
<>""
means "not blank"
So if you were wanting to change it to say "is blank", you would use
=""
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Can you help me understand why the = is used for "" but not for <>""? This is an example of what seems like inconsistencies in formulas that are really confusing.
Thanks for the detail, though. That worked.
Lori
-
=""
means "equal to blank"
<>""
means "not equal to blank".
= --> equal
<> --> not equal
"" --> blank
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!