Using true and false functions in Airtable

  • Updated on Dec 14, 2023
  • Published on Jul 6, 2022
  • 1 minute(s) read

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

Introduction 

Plan availability

All plan types 

Platform(s)

Web/Browser, Mac app, and Windows app

Related reading

TRUE() and FALSE() functions overview

TRUE() and FALSE() functions

NOTE

TRUE()and FALSE() functions generate the logical value true and false, respectively, and output a 1 or a 0.

360098989374s0BC41CAC314A3018D0E6FD8517B05B2AE664EE51C695569579C0DBF2FA46CC4F1606546502242image.png

These functions are more commonly used within a conditional statement, like this:

IF ({Cost} = {Price}, TRUE (), FALSE ())
360098989354s0BC41CAC314A3018D0E6FD8517B05B2AE664EE51C695569579C0DBF2FA46CC4F1606546517738image.png

Using TRUE() in Airtable

Using TRUE()

Using another example scenario, let's say that you're a hiring manager and want to track candidates who have made it through three major stages in the hiring process.

You could use TRUE() within a conditional statement to output one message if they passed all stages, and another message if they didn't.

IF(
   AND(
      {Stage 1}=TRUE(),   
      {Stage 2}=TRUE(),
      {Stage 3}=TRUE()
   ),
   "Passed all stages",
   "Not all stages complete"
)

Using FALSE() in Airtable

Using FALSE()

Let's use the same hiring process scenario as before, except we'll structure the formula differently to utilize FALSE()instead.

IF(
   AND(
      {Stage 1},
      {Stage 2},
      {Stage 3}
   )
   = 
   FALSE(),
   "Not all stages complete",
   "Passed all stages"
)

You'll notice that the two different formulas output the exact same result (see examples below).

1500000118502s0BC41CAC314A3018D0E6FD8517B05B2AE664EE51C695569579C0DBF2FA46CC4F1606546648246formula1.jpg

IF(
   AND(
      {Stage 1}=TRUE(),   
      {Stage 2}=TRUE(),
      {Stage 3}=TRUE()
   ),
      "Passed all stages",
      "Not all stages complete"
)

1500000118482s0BC41CAC314A3018D0E6FD8517B05B2AE664EE51C695569579C0DBF2FA46CC4F1606546651641formula2.jpg

IF(
   AND(
      {Stage 1},
      {Stage 2},
      {Stage 3}
   )
   = 
   FALSE(),
      "Not all stages complete",
      "Passed all stages"
)