Need assistance with IF Or and IF Not formulas

Options
Chris Downes
Chris Downes ✭✭
edited 02/02/23 in Formulas and Functions

current formula has syntax errors : IF(OR(Region@row = "a", Region@row = "b", Region@row = "c", Region@row = "d", Region@row = "e"), "email1", IF(OR(Region@row = "F", Region@row = "g", Region@row = "h", Region@row = "SMA"), "email2"), If(NOT(Region@row="a", region@row="b", region@row="c"), [departmentdirectoremail]@row, ""))

Basically, I want to be able to say, anything that falls in regions a-e = "email1", anything regions f-SMA = "email2", and anything that is not one of those regions = cell reference in that row.


Any ideas? Where am I going wrong?

Thanks!

Answers

  • Katie G
    Katie G ✭✭✭✭
    Options

    Hi Chris, you're so close! There was a minor issue with the parenthesis after "email2". then since you've already ruled out a/b/c in the first IF statement, I think you can just skip that and show the other cell at that time.


    Try this and see if it does what you want:

    =IF(OR(region@row = "a", region@row = "b", region@row = "c", region@row = "d", region@row = "e"), "email1", IF(OR(region@row = "F", region@row = "g", region@row = "h", region@row = "SMA"), "email2", departmentdirectoremail@row))

  • Chris Downes
    Options

    Thanks Katie! I just tried that and it doesn't work, still getting a syntax error.

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Options

    @Chris Downes

    IF(OR(Region@row = "a", Region@row = "b", Region@row = "c", Region@row = "d", Region@row = "e"), "email1", IF(OR(Region@row = "F", Region@row = "g", Region@row = "h", Region@row = "SMA"), "email2", If(NOT(Region@row="a", region@row="b", region@row="c"), [departmentdirectoremail]@row, "")

  • SWilson
    SWilson ✭✭
    Options

    As Katie said, your parens were off. Her syntax is correct.

    You can try screenshotting the actual sheet and your formula. You may have a typo or other simple error we can't see here.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!