Help

Re: Assistance with Modifying A Formula

487 3
cancel
Showing results for 
Search instead for 
Did you mean: 
John_Dlouhy
7 - App Architect
7 - App Architect

Greeting Airtable Community!

I have an existing formula that is returning the correct results:

IF(AND({Guest Code}=‘DONOR’,{Status S2}=‘Yes’),First&" "&Last)

I now need to modify the formula to include {Status S2}=‘Yes FUP’ and the ‘Yes’ variable.

Any assistance on this would be greatly appreciated, as always.

John

4 Replies 4

Can you clarify – do you want to require that {Status S2} contains BOTH “Yes FUP” AND “Yes”, or EITHER “Yes FUP” OR “Yes”?

Thanks Jeremy. I’m sorry I didn’t clarify that. It would be
EITHER ‘Yes FUP’ or ‘Yes’.

This should do it:

IF(
   AND(
      {Guest Code}='DONOR',
      OR(
         {Status S2}='Yes',
         {Status S2}='Yes FUP'
      )
   ),
   First&" "&Last
)

Thanks Jeremy! I will try this now!!