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", [subproduct]@row = "DEF"), "Colleague name"),
I hope this isn't too minimal an example  does anyone have any suggestions, please?
Many thanks,
Sarah
Best Answer

Hi @SKP ,
Without seeing the actual formula, it looks like you currently have an extra set of parenthesis.
=IF(AND([product]@row = "ABC", [subproduct]@row = "DEF"), "Colleague name",IF(AND([product]@row = "GHI", [subproduct]@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
Answers

Hi @SKP ,
Without seeing the actual formula, it looks like you currently have an extra set of parenthesis.
=IF(AND([product]@row = "ABC", [subproduct]@row = "DEF"), "Colleague name",IF(AND([product]@row = "GHI", [subproduct]@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

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.

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

@SKP Fantastic! I'm glad it was a simple fix. Have a great day!
Help Article Resources
Categories
Check out the Formula Handbook template!