Errors Which Are Displayed for Formulas

Article Number:040497

There are two types of formula errors. One is the error displayed when you set a formula and the other is the error displayed when you enter records.

Errors Displayed When Setting a Formula

The following section describes the errors you might get when you enter and save a formula on the App Settings page.

Error Cause and Solution
You have entered a full-width symbol "XX". Use a half-width symbol "XX" or check that the entered value is correct. This error is displayed on the formula setting screen when you entered a full-width symbol wrongly, instead of a half-width symbol.

For example, this error is displayed in the following formula because it contains a full-width quotation mark (”).
Example: IF=(Option=”

On the other hand, this error is not displayed in the following cases.
  • When full-width symbols are used in a correct way to write a formula.
    Example 1: IF=(Option="Breakfast(Buffet)",1500,0)
  • When you enter an opening parenthesis in full-width, there is a half-width quotation (") before the full-width parenthesis and you haven’t typed a closing quotation (") yet:
    Example 2: IF=(Option="Breakfast(
* In the above Example 1 and 2, the full-width parenthesis is used in the formula to write "(buffet)".
The field code in the formula does not exist or has invalid format. This error is displayed in the following cases:
  • The formula contains a field code that does not exist
  • The formula contains a field that cannot be referenced in it
    See "Fields That Can Be Referred by Formulas".
  • Full-width symbols, including & and four arithmetic operators (+ - * /), are used
Check if the field code is correct and you are not using the full-width symbols in the formula.
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.
  • A string starting with a half-width number is specified as a field code.
    - Check if you have specified the field name in the formula.
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 more 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, 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.
Refer to Data Types of Values Referenced 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 the field value or the calculated result is either of the following date and time in UTC (Coordinated Universal Time):
    - January 1, 1000 00:00 (UNIX time: -30610224000) or earlier
    - December 31, 9999 23:59 (UNIX time: 253402300799) or later
  • 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", "Tokyo")

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. Image Image

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. Image

Now, the calculated result "Clear" is displayed. Image