Skip to main content

New support article: How to conditionally display missing field values

J

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.

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

S
  • Student_Service
  • Participating Frequently
  • 5 replies
  • September 16, 2020

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

)

J
Student_Service wrote:

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

Reply


Most helpful members this week

Terms & Conditions