Using true and false functions in Airtable

TRUE() and FALSE() functions overview

TRUE()and FALSE() functions generate the logical value true and false—outputting 1’s or 0’s and are often used in conditional statements like:

IF ({Cost} = {Price}, TRUE (), FALSE ())

Using TRUE() in Airtable

Using TRUE() within a conditional statement allows you to output one message if the output is “True” and another message if it is “False.” In the binary example below, one message shows if a student “Passed” an exam and another message if they “Failed.”

IF(
   AND(
      {Stage 1}=TRUE(),   
      {Stage 2}=TRUE(),
      {Stage 3}=TRUE()
   ),
   "Passed",
   "Failed"
)

Using FALSE() in Airtable

 Using FALSE() within a conditional statement allows you to output one message if the output is “False” and another message if it is “True.” In the binary example below, one message shows if a student “Passed” an exam and another message if they “Failed.”

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