I create the formula , but keep getting the missing closing parentaies error. what am I missing?

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

Case(IsNull([Received $200 non-refundable deposit]),"#D7DFF2",[Date]<Today(),"#FFE9AA"[Eligible to attend BTG course]=false,"pink",([Enrolled]=true,"#EAF5D8")

Photo of Antwan

Antwan

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
Multiple Typos. Try this:

If(
  IsNull([Received $200 non-refundable deposit]), "#D7DFF2",
  [Date] < Today(), "#FFE9AA",
  not [Eligible to attend BTG course], "pink",
  [Enrolled], "#EAF5D8"
)
I think it needs to be an IF

IF(
  IsNull([Received $200 non-refundable deposit]), "#D7DFF2",
  [Date] < Today(), "#FFE9AA",
  not [Eligible to attend BTG course], "pink",
  [Enrolled], "#EAF5D8"
)

Also, what field type is [Received $200 non-refundable deposit]
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
>I think it needs to be an IF

What he said!