Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Find Difference Between Fields

Topic Labels: Formulas
537 2
Showing results for 
Search instead for 
Did you mean: 

Hi There! I’m looking to find the difference between two fields. Specifically, I have a field for who Registered for a meeting and a field for who actually Attended that meeting. I want to be able to see who Registered but did not attend OR who Attended but did not register. Thanks for any help you can provide!

2 Replies 2

in your output field, do you want results like, ‘Attended and Registered’, ‘Only Attended’, and ‘Only Registered’?

If so you’ll want to do something like =if(AND({Attendance}=“yes”,{Registered}=“yes”),“Attended and Registered”,if({Attendance}=“yes”,“Only Attended”,“Only registered”))

I may have forgotten a parenthesis, but basically this is probably the type of IF() and AND() structure you would need.

Thank you for this and I’m sure it would work but it looks a bit greek to me. I’m very new to AirTable. Where would I add this “code”? Thank you!!