I'm very new to Airtables and I'm trying to figure out some formulas. For now, I'm trying to figure out training completion from my base. The 'Training Completed' field is a multi-selection field (also a linked field) that shows all training an employee has completed. I want to create a formula where if a person has completed Training A and Training B, then the result is 'completed'. So basically, out of the many options that present themselves in the multi-selection field, I need to select 2 specific pieces of training that indicate that a program has been completed. I've tried using the IF (FIND) formula. I'm getting part of it correct, where I've just included Training A, but when I try to add in Training B, the formula doesn't work. This is what I have so far:
Solved! Go to Solution.
Hi Adam, your formula did indeed help me. I realized that for the second training, I actually had to pull from another tab. That's where I was going wrong. But with your formula and having corrected the second tab, it worked. 🙂