Does anyone know why the system is rejecting this calculated field as invalid?

[AgnesLe]

I'm trying to calculate how many times 'Automotive' is selected in a multi select drop field call "GBM - Verticals". Here is my calculated field that will return a number either 1 or 0: IF(CONTAINS("Automotive",GBM - Verticals),1,0) where "GBM - Verticals" is a custom drop-down field. The system kept telling me that my expression is invalid.

[AdinaPi1]

It doesn’t like the hyphen, so you need to put the field name in the curly brackets like this: IF(CONTAINS("Automotive",{GBM - Verticals}),1,0)

[AgnesLe]

Adina, Thank you! This worked. Appreciate the input!