Errors Which Are Displayed for Formulas

There are two types of errors which are displayed for formulas. One is the error displayed in the screen to set 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.
See "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 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. Since function names are case-sensitive, you must specify them using uppercase characters.
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.
To use one of the fields in the table in the calculation formula, use the SUM function. This error is displayed when referring a field in the table from the formula which is specified for a field outside of the table. Only the SUM function can be used for such reference.
See "SUM Function: Sum Calculation".

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 text.
When the Calculated Result in the Calculated Field Is a String (#CONVERT! error)
#PRECISION! The result value exceeds the number of significant digits.
For details on how to set the significant digits, see 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 string to a value
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.
See "Fields That Can Be 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 (#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 "Clear" is displayed.