Combining IF and OR
What I'm trying to say is:
If A1 Rank = 1, 2 or 3 then Awareness
If D Rank = 1, 2 or 3 then Desire
If K Rank = 1, 2 or 3 then Knowledge
If A2 Rank = 1, 2 or 3 then Ability
If R Rank = 1, 2 or 3 then Reinforcement
If none is true then NONE
=IF(OR([A1 Rank]@row = “1”, [A1 Rank]@row = “2”, [A1 Rank]@row = “3”), “Awareness”, IF(OR([D Rank]@row = “1”, [D Rank]@row = “2”, [D Rank]@row = “3”), Desire, IF(OR([K Rank]@row = “1), [K Rank]@row = “2”, [K Rank]@row = “3”), Knowledge”, IF(OR([A2 Rank]@row = “1”, [A2 Rank]@row = “2”, [A2 Rank]@row = “3”), “Ability”, IF (OR([R Rank]@row = “1”, [R Rank]@row = “2”, [R Rank]@row = “3”), Reinforcement, “NONE”)))))
I keep getting an #unparseable error
Answers
-
I seem missing quotation marks, might be more this is just what I see
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!