Please assist with a text formula?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Case([# ***TOTAL*** BOARDS DELIVERED]>[Order - Job - BOARD COUNT],
"<div style=\"background-color:#ffff00;\"> NOTIFY OFFICE IF BOARD COUNT DELIVERED IS GREATER THAN BUILDER BOARD COUNT</div>",
"")

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.
Photo of Lynne8817

Lynne8817

  • 600 Points 500 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Xavier Fan

Xavier Fan, Champion

  • 570 Points 500 badge 2x thumb
Instead of the Case function, use the If function (in your formula - just change from "Case" to "If"):

If([# ***TOTAL*** BOARDS DELIVERED]>[Order - Job - BOARD COUNT],

"<div style=\"background-color:#ffff00;\"> NOTIFY OFFICE IF BOARD COUNT DELIVERED IS GREATER THAN BUILDER BOARD COUNT</div>",

"")