Logical arguments

The SWITCH() function can be a big time-saver when you’re working with conditional-heavy formulas (e.g. nested IF() statements). Learn more about using this function as an alternative to nested IF() statements. NOTE When writing long form...

This article covers how to evaluate arguments using AND() and OR() to streamline your team's and organization's work. Introduction  Understanding AND() and OR() Using AND() in Airtable Using AND() AND() can be used ...

Finding an empty field This content is part of a guided course that includes the BLANK() function. The BLANK() function can identify an empty value in a field or output an empty value in a formula. Typically, the BLANK() function is used withi...

This article covers how to use TRUE()  and FALSE()  functions to streamline your team's and organization's work. Introduction  TRUE() and FALSE() functions overview TRUE() and FALSE() functions NOTE TRUE() and FALSE()...

In this article, we’ll cover different approaches to identifying and outputting errors in a formula field. Introduction  ERROR() ERROR() is a logical function that returns the error value. This means that you can output an error messag...

This article covers how to use XOR  and NOT() functions to streamline your team's and organization's work. Introduction  Using XOR() in Airtable  Using X0R() XOR  returns a true value if an odd number of arguments ...