Skip to main content
Question

Help with color coding report

  • March 27, 2018
  • 0 replies
  • 43 views
Code:
Case([Contact Type], "No Longer with Firm", "#82BE41",
"Terminated Client", "#FFA07A",
"No Longer on the Engagement", "#E1EED9",
"Not a Current Client", "#42BCE8", "")


Error received:
Formula error -- Bad or missing arguments in function call

The types of the arguments or the number of arguments supplied do not meet the requirements of the function Case.

The function is defined to be Case ( x, val1,result1, ..., else-result).

You may need to do one of the following to fix the problem:
  • Choose the right number and type of arguments.
  • Use a type conversion function to convert the arguments you are using to the correct type.
  • Choose a different function
    This topic has been closed for replies.

    Can you tell us what field type is [Contact Type]

    Maybe it is a multi-select field?
    • LisaSell1
    • Quickbase Alumni
    • March 27, 2018
    The Case statement doesn't need the final clause - this is all you need to do:
    Case([Contact Type], "No Longer with Firm", "#82BE41",
    "Terminated Client", "#FFA07A",
    "No Longer on the Engagement", "#E1EED9",
    "Not a Current Client", "#42BCE8")
    Terms & ConditionsAccessibility statement