Help

Re: New support article: How to conditionally display missing field values

520 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jason
Airtable Employee
Airtable Employee

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
Student_Service
5 - Automation Enthusiast
5 - Automation Enthusiast

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