Having issues with the following Case function. I'm getting an error in Process Builder: "The formula expression is invalid: Syntax error. Missing ')' . I can't seem to figure out what I'm missing. I'm trying to update the associate campaigned based on the name of the opportunity. Here is the case formula:

CASE([Opportunity].Name,"Individual Ticket",7011I000000CZq1QAG,
"Chosen Partner",7011I000000CZq6QAG,
"Bronze Partner",7011I000000CZprQAG,
"Silver Partner",7011I000000CZqBQAW,
"Exclusive Gold Partner",7011I000000CZqGQAW,
"Couple's Tickets (Admit 2)",7011I000000CZqLQAW,7011I000000CZqLQAW)

Thanks for the help


1 Answer 1


The ID values need to be in quotes, too:

"Individual Ticket","7011I000000CZq1QAG",
"Chosen Partner","7011I000000CZq6QAG",
"Bronze Partner","7011I000000CZprQAG",
"Silver Partner","7011I000000CZqBQAW",
"Exclusive Gold Partner","7011I000000CZqGQAW",
"Couple's Tickets (Admit 2)","7011I000000CZqLQAW",

Everything else looks okay to me.

  • Thanks! That was it! Mar 23, 2019 at 14:53

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .