Using true and false functions in Airtable
  • 14 Dec 2023
  • 1 Minuto para leer
  • Oscuro
    Ligero
  • PDF

Using true and false functions in Airtable

  • Oscuro
    Ligero
  • PDF

The content is currently unavailable in Spanish. You are viewing the default English version.
Resumen del artículo

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


¿Te ha sido útil este artículo?