Using XOR() and NOT() functions in Airtable

Prev Next
Plan AvailabilityAll plan types
Required permissionsOwner / Creator - Can add, delete, duplicate, rename, and customize fields
Platform(s)Web/Browser, Mac app, and Windows app (with some additional limited support on mobile)

XOR() function overview

The XOR function returns a “True” value when an odd number of arguments are “True.”

Using XOR() in Airtable

In the example below, the XOR function outputs a message if all but 1 checkboxes are selected:

IF(
   XOR(
      {Checkbox 1}, 
      {Checkbox 2}
   ), 
   "Missing Checkmark"
)

1500000115841XOR001.jpg

 FAQ? /

What happens when using NOT() instead of XOR()?

If iNOT() is used instead of XOR(), it reverses the logical value of its argument. For example, 100 > 75 evaluates as “True”, whileNOT(100 > 75) is “False".”