Skip to main content

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

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

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’.

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

)

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!!

Reply


Terms & Conditions