Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Delay sending an email based upon another field

Topic Labels: Formulas
193 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Here is what my formula looks like. I can not get Airtable to accept it. Can you say why?
Current formula
IF(
({Sales Rep}!=""
),
AND(
NOW()>={Followup Date}),
“Delay Notification”)

Proposed formula
IF(
OR(
AND(
{Sales Rep}!=BLANK(),
{Followup Date},
NOW()>={Followup Date}
),
AND(
{Sales Rep}!=BLANK(),
{Followup Date}=BLANK()
)
),
“Delay Notification”,
“Send Notification”
)

0 Replies 0