Skip to main content

Find Difference Between Fields

S

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

M
Forum|alt.badge.img+4
  • Mike_McLaughlin
  • Participating Frequently
  • 97 replies
  • February 1, 2019

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.

S

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

Reply


Most helpful members this week

Terms & Conditions