Help

Help with AND / OR / IF function

413 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Eddie_Ross
4 - Data Explorer
4 - Data Explorer

Hello all,

Thank you in advance for your help. It seems I have a simple formula requirement but can’t get my head around the Airtable syntax. Pseudo code below:

IF((eligible = yeswithplan OR eligible = yeswithoutplan) AND (purchase timeframe
= 12 weeks OR purchase timeframe = 3 - 6 MONTHS) AND (stage != just looking))
RETURN true OR(appointment != empty) RETURN true ELSE false

Would someone be so kind to translate this into the formula for Airtable?

Eddie

1 Reply 1

Welcome to the community, @Eddie_Ross! :grinning_face_with_big_eyes: Maybe this will help:

If you need specific help after checking that out, let me know! :slightly_smiling_face: