Errors Which Are Displayed for Formulas

There are two types of errors which are displayed for formulas. One is the error displayed when setting forms, and the other is the error displayed when entering records.

Errors Displayed When Setting Forms

This section explains the errors that are displayed when saving forms in the screen to set forms.

Error Cause and Solution
The field code in the formula does not exist or has invalid format. Either the field code does not exist, or the field cannot be used for the formula.
You must check whether you are using an appropriate field code for the field specified in the formula.
Refer to "Fields That Can Be Referred by Formulas".
Field references cause an endless loop. This error is displayed when you specify the Calculated field as a formula for the Calculated field. This error is also displayed when referring the Calculated field B from the Calculated field A, or when referring the Calculated field A from the Calculated field B.
Function x requires y arguments. This error is displayed when the number of arguments specified for the YEN/DATE_FORMAT/NOT/IF/CONTAINS function is not enough.
Function x requires y or more arguments. This error is displayed when the number of arguments specified for the AND/OR/SUM function is not enough.
Function ROUND (or ROUNDUP/ROUNDDOWN) requires 1 or 2 arguments. This error is displayed when the number of arguments specified for the ROUND/ROUNDUP/ROUNDDOWN function is not enough.
Function x does not exist. This error is displayed when you specified a function which cannot be used in Kintone.
Function x accepts up to y arguments. This error is displayed when you specified more than acceptable number of arguments for the formula for the Calculated field or the Text field.
Invalid formula format. This error is displayed when the formula cannot be solved. For example:
  • Parentheses are not paired.
  • Operator is incorrectly placed.
  • Line break is inserted within the text which is enclosed in double quotation marks ("").
  • Line break is inserted within a number.
Relevant function is not used for the value of the array type. As for values of array types and their usage, refer to the help. This error is displayed when a formula refers to the Check box/Multi-choice field, or a field in a table is referred outside from the table.
In both cases, a formula refers to an "array type field".

To refer to the Check box/Multi-choice field from a formula, or to refer to a text type field (Text, Radio button, Drop-down, or Lookup whose source is Text) in a table outside from the table, use the CONTAINS function.
Note that a formula which resides outside of a table cannot refer to the Check box/Multi-choice field in the table.

To refer to a numeric type field (Calculated field, Number field, or Lookup whose source is Number) in a table outside from the table, use the SUM function.

For using SUM and CONTAINS functions, refer to the following pages:
CONTAINS Function:Calculation using Check Boxes and Multi-Choices
SUM/CONTAINS Functions: Calculations in Tables

Errors Displayed When Entering Records

This section explains errors that are displayed in the field where a formula is set, when entering records.

Error Description
#CONVERT! The value cannot be converted. This error is displayed when the calculated result in the Calculated field is a string. The result value in the Calculated field should be either number, date and time, date, time or hour.
Use the Text field if the result value becomes a string. For details, refer to the following page.
When the Calculated Result in the Calculated Field Is a String (Cause and Solution for #CONVERT! error)
#PRECISION! The result value exceeds the number of significant digits.
For details on how to set the significant digits, refer to the following page:
Setting the Significant Digits of Numbers and the Rounding Method
#VALUE! This error is displayed when the value type or the operator is not appropriate.
Example 1: Adding a number to a string
Example 2: Using the + operator for concatenating strings
For example, any number you entered in a drop-down is treated as a string. It cannot be used for calculation as a number.
Refer to Data Types of Values That Are Referred by Formulas
#ERROR! (Not for DATE_FORMAT function) The calculation cannot be performed. For example, when dividing a number by zero (0), exponent exceeds 100 or falls below -100, etc.
#ERROR! (For DATE_FORMAT function) This error is displayed in the following cases:
  • When you specified the date on or after November 21, 2286.
  • When the field value or the calculation result becomes the date on or after November 21, 2286.
  • When the number of characters in the formula exceeds 64 characters.
  • When invalid time zone is specified as the third argument.
    Example: DATE_FORMAT(Date and time, "YYYY/MM/DD a hh:mm", "invalid_timezone")

When the Calculated Result in the Calculated Field Is a String (Cause and Solution for #CONVERT! error)

If you set a formula in the Calculated field when the calculated result is a string, #CONVERT! error is displayed.

In this case, calculated result can be displayed by using the Text field. Select "Calculate automatically" in the Text settings screen, and then enter a formula.

Now, the calculated result "Pass" is displayed.