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
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", [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
Answers
-
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
-
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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!