We do not have "County" in Zoho CRM but we do have City.  And we know which Cities are in the County.  So I wish to make a Custom Formula that says - IF the Town is in this County, name it this, if not, do this instead.

I have attempted to make this query using following code:

if(Job City = 'Baldwin,Bridgton, Brunswick, Cape Elizabeth, Casco, Chebeague Island, Cumberland, Falmouth, Freeport, Frye Island, Gorham, Gray, Harpswell, Harrison,Long Island,Naples, New Gloucester, North Yarmouth, Portland, Pownal, Raymond, Scarborough, Sebago, South Portland, Standish, Westbrook, Windham, Yarmouth','Cumberland','Other')

This is accepted, BUT all of the towns come up as "Other." I think I am doing something wrong with the syntax, really, what it is means if, IF Job City = (this or this or this or this or this) = Cumberland, and if = (none of those) = Other

Any assistance?

- Fred