Need assistance with IF Or and IF Not formulas

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!

Find more posts tagged with

Accepted answers

All comments

Katie G

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

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

Mike TV

@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

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.