Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

New support article: How to conditionally display missing field values

Topic Labels: Formulas
472 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi folks, just a quick announcement about a new formula article that walks through how to check for missing field values, and display them conditionally in a formula field.

Here’s an example from the article of what the end result looks like.

Conditional field check

You can use and modify this approach for any number of workflows, so we hope it’s helpful! If you have any requests for support articles around formulas (or anything else!), just let me know :thumbs_up:

2 Replies 2

Hi! I tried to adapt this for a checklist of mine, and the formula isn’t accepted. Can you tell me what I’m doing wrong? Here’s my adapted formula:

IF(

{NEW: Canceled/No Show}=BLANK(),

“Attended” & ", " & “\n”) &

IF(

{NEW: Send Materials}=BLANK(),

“Send Materials” & ", " & “\n”) &

IF(

{Scored}=BLANK(),

“Score Test” & ", " & “\n”) &

IF(

{NEW: Essay?}=BLANK(),

“No Essay” & ", " & “\n”) &

IF(

{NEW: TW: Upload docs}=BLANK(),

“Upload docs” & ", " & “\n”) &

IF(

{NEW: TW: Add to Results}=BLANK(),

“Add to Results” & ", " & “\n”) &

IF(

{NEW: Set follow-up in Tasks}=BLANK(),

”Set follow-up Tasks” & ”, ” & ”\n”)

)

You had one extra parenthesis at the end – but also, you have a mixture of “curly” quotes and “straight” quotes in your formula text. Airtable’s formula editor doesn’t like “curly” quotes and will throw an error if they are in your formula.

Try copy-pasting this version of your formula where I’ve removed the extra parenthesis, and made sure all the quotes are of the “straight” variety:

IF(
   {NEW: Canceled/No Show}=BLANK(),
   "Attended" & ", " & "\n"
) &
IF(
   {NEW: Send Materials}=BLANK(),
   "Send Materials" & ", " & "\n"
) &
IF(
   {Scored}=BLANK(),
   "Score Test" & ", " & "\n"
) &
IF(
   {NEW: Essay?}=BLANK(),
   "No Essay" & ", " & "\n"
) &
IF(
   {NEW: TW: Upload docs}=BLANK(),
   "Upload docs" & ", " & "\n"
) &
IF(
   {NEW: TW: Add to Results}=BLANK(),
   "Add to Results" & ", " & "\n"
) &
IF(
   {NEW: Set follow-up in Tasks}=BLANK(),
   "Set follow-up Tasks" & ", " & "\n"
)