Listing Options in IF formula

I've looked at the forums and tried as many variations in the formula as I can think of, so I need some help. 

My two columns (both drop downs):

Payee Name

Payee Position *(location of formula)

I'm trying to get Payee Position to automate the position title for each payee. Here's what I've got to work for one position title:

IF(OR([Payee Name]2 = "John Smith", [Payee Name]2 = "Jane Doe", [Payee Name]2 = "Sally Sue"), "Benefit Strategist")   yes

But I've got other Payee Names that are not just Benefit Strategists...I've also got Account Executives and Production Partners. How would I include those?? I've thought:

IF(OR([Payee Name]2 = "John Smith", [Payee Name]2 = "Jane Doe", [Payee Name]2 = "Sally Sue"), "Benefit Strategist"), IF(OR([Payee Name]2 = "Fred Flinstone", [Payee Name]2 = "Mike Miller", [Payee Name]2 = "Samwise Gamgee"), "Account Executive")  no

IF(OR([Payee Name]2 = "John Smith", [Payee Name]2 = "Jane Doe", [Payee Name]2 = "Sally Sue"), "Benefit Strategist" OR([Payee Name]2 = "Fred Flinstone", [Payee Name]2 = "Mike Miller", [Payee Name]2 = "Samwise Gamgee"), "Account Executive")  no

IF(OR([Payee Name]2 = "John Smith", [Payee Name]2 = "Jane Doe", [Payee Name]2 = "Sally Sue"), "Benefit Strategist"), =IF(OR([Payee Name]2 = "Fred Flinstone", [Payee Name]2 = "Mike Miller", [Payee Name]2 = "Samwise Gamgee"), "Account Executive")  no

None of those have worked, so I am really needing some help!

Thanks a bunch!

-Stephanie

 

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!