Help

Delay sending an email based upon another field

Topic Labels: Formulas
360 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Myron_Waldman
4 - Data Explorer
4 - Data Explorer

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