Greetings Airtable Community!

I am hoping a more experienced user can provide guidance on a formula.

I currently have a formula field:

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

This is returning the correct data (e.g. Robert Jones); however, I need to expand the formula to *also include the guest* of First Last (e.g. Robert Jones, Sally Smith). The guest field names are With First and With Last.

Any assistance would be greatly appreciated. I’m up against a deadline, so it’s time sensitive.

Cheers and thanks,

John