My Case formula is returning a syntax error but I can't figure out what - precisely - is wrong.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I want my Case formula to look in the [First name] field on my form. If [First name] =  "LESLIE" I would like it returned with "Craig", and if the [First name] = "Gary" I would like this field returned "Sam". And if the [First name] field does not contain either "LESLIE or Gary" I would like it left with whatever is currently in there. Each time I try to save, it is returning a Syntax error. What am I missing?

Case(
[First name],
LESLIE, "Craig",
Gary, "Sam",
[First name]
)

Thanks a million!
Photo of ROBERT

ROBERT

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
You have to wrap all text strings with "

Case(
[First name], 
"LESLIE", "Craig",
"Gary", "Sam",
[First name]
)
Photo of ROBERT

ROBERT

  • 0 Points
Can't believe I missed that, thanks!