The IS_EMPTY() function is used to check whether a cell or value is empty.

It is very useful for validating data in formulas and ensuring that certain information is present before processing it.

➡️ Display Name:

➡️ Syntax :

field1: This is the data or value you want to check. 

➡️ Example:

➡️ Result:
This checks if the variable Name is empty. It returns 1 if the variable is empty, and 0 if it contains a value.

• 1 function 🔵: IS_EMPTY() is the function used to check if the value is empty.
• 1 field 🟡: Name is the value or field you want to check.

🟰 Expected Result:

• If Name is empty, the function will return true.
• If Name contains a value, the function will return false.

Make the Distinction

• EMPTY() is mostly used to check individual fields or values in a database or spreadsheet.
• IS_EMPTY() is better suited to check if more complex data structures, like lists or arrays, are empty.
•  

• 📊 Direct Comparison:

  Function	Usage	Tested On	Result
  EMPTY()	Check if a field is empty	Field, simple column	true/false depending on if the field is empty
  IS_EMPTY()	Check if an object or list is empty	Lists, datasets, objects	true/false depending on if the object is empty

Depending on the nature of your data (simple field or dataset), you will use one or the other to ensure that your empty value tests are accurate.

📝 Tip: For visibility in the form of a check box ☑️ of the result of your condition, choose the “Boolean” output format in the “option” menu of the column 
1 = will return check ☑️

0 = will return unchecked ☐