Using true and false functions in Airtable
  • 21 Nov 2022
  • 1 Minute to read
  • Dark
    Light
  • PDF

Using true and false functions in Airtable

  • Dark
    Light
  • PDF

Article Summary

When creating conditional formulas, TRUE()and FALSE() functions assist in yielding specific true and false results when you need to explicitly provide that type of output. This article discusses how these functions work and common ways to use them in your formulas. This article is part of a guided course which you can view here.

The TRUE()and FALSE() functions are very straightforward in their use. They each generate the logical value true and false, respectively, and output a or a 0.

360098989374s0BC41CAC314A3018D0E6FD8517B05B2AE664EE51C695569579C0DBF2FA46CC4F1606546502242image.png

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

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

360098989354s0BC41CAC314A3018D0E6FD8517B05B2AE664EE51C695569579C0DBF2FA46CC4F1606546517738image.png

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"
)

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"
)

Formula Foundations

This article is part of a guided course that helps you learn how to use Airtable formulas.

View Course



Was this article helpful?