Hey,

I have a formula field, either text or number, that I want to use an IF CONTAINS formula on a multi select picklist. Ideally there would be several of these so I can get different outcomes similar to a case statement, but just the basic formula is giving me an error when I Check Syntax:

'Error: Syntax error missing ')'

Hear is my initial formula:

IF(INCLUDES(Project_TYPE__c, "Equipment"), 1, 2)

I've also tried IF(INCLUDES(Project_TYPE__c, "Equipment"), "1", "2")

With the same error.

I verified the field is available in the Insert Field pop-up. I've seen other threads where they discuss doing this and nesting the formula to work through the values, but I'd like just to get this one line to work.

Thanks for any help!