Message Column Formula Syntax error

Hi folks,

I've needed to extend a formula to add in a lot more people under more conditions. I'm getting the syntax error but I don't think it's the quote marks and the column that the formula is in is definitely 'text/number'.

Currently, there's a formula with 5 IF statements that works with no issues with each statement like this:

=IF([Assigned To]@row = "ABC department", "Colleague name" etc.

The new changes are dependent on a couple of columns so I was going to add in some IFs and ANDs to navigate that:

I've done that like this for the 12 extra colleagues that need adding, (using a different formula that I know works and contains IFs with ANDS to guide me):

Per colleague remit:

=IF((AND([product]@row = "ABC", [sub-product]@row = "DEF"), "Colleague name"),

I hope this isn't too minimal an example - does anyone have any suggestions, please?

Many thanks,

Sarah

Find more posts tagged with

Formulas

Accepted answers

Heather Duff

Hi @SKP ,

Without seeing the actual formula, it looks like you currently have an extra set of parenthesis.

=IF(AND([product]@row = "ABC", [sub-product]@row = "DEF"), "Colleague name",IF(AND([product]@row = "GHI", [sub-product]@row = "JKL", "Other colleague name", IF(AND...

Hope this helps! If it doesn't fix it and you want to provide a screenshot of your formula, you can redact any sensitive information.

Best,

Heather

All comments

Heather Duff

Hi @SKP ,

Without seeing the actual formula, it looks like you currently have an extra set of parenthesis.

=IF(AND([product]@row = "ABC", [sub-product]@row = "DEF"), "Colleague name",IF(AND([product]@row = "GHI", [sub-product]@row = "JKL", "Other colleague name", IF(AND...

Hope this helps! If it doesn't fix it and you want to provide a screenshot of your formula, you can redact any sensitive information.

Best,

Heather

Paul Newcome

Can you provide the exact formula that is causing the issue?

The only thing I see in the above example is the opening parenthesis before the AND and the closing parenthesis after the "Colleague name" are not needed and liable to break the formula.

SKP

Thank you, everyone! It was the extra pair of parentheses :)

All sorted.

Heather Duff

@SKP Fantastic! I'm glad it was a simple fix. Have a great day!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.