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
 62.4K Get Help
 364 Global Discussions
 202 Industry Talk
 430 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!