Skip to main content
Solved

Using IF and FIND in a formula

  • January 17, 2023
  • 4 replies
  • 142 views
A
Forum|alt.badge.img+3

Hi everyone,

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:

IF(FIND("Training A", {Training Completed}), "Completed", "Not Completed") 
 
I need to add in Training B to the mix as well. Can anyone help me with this? 

Best answer by TheTimeSavingCo

Add an "AND()" in there, so something like

IF( AND( FIND("Training A", {Training Completed}), FIND("Training B", {Training Completed}) ), "Completed", "Not Completed" )

 

 

    4 replies

    TheTimeSavingCo
    Forum|alt.badge.img+31

    Add an "AND()" in there, so something like

    IF( AND( FIND("Training A", {Training Completed}), FIND("Training B", {Training Completed}) ), "Completed", "Not Completed" )

     

     

    Adam, Airtable Consultant - thetimesaving.company
      A
      Forum|alt.badge.img+3
      • amykalra
      • Author
      • Participating Frequently
      • January 18, 2023

      Add an "AND()" in there, so something like

      IF( AND( FIND("Training A", {Training Completed}), FIND("Training B", {Training Completed}) ), "Completed", "Not Completed" )

       

       


      Thank you Adam, I'm trying this, but now it's not pulling up any results. 😞 Not sure what to do....

      TheTimeSavingCo
      Forum|alt.badge.img+31

      Thank you Adam, I'm trying this, but now it's not pulling up any results. 😞 Not sure what to do....


      Interesting!  Could you share a screenshot of your table with some example data please?

      Adam, Airtable Consultant - thetimesaving.company
      A
      Forum|alt.badge.img+3
      • amykalra
      • Author
      • Participating Frequently
      • January 20, 2023

      Interesting!  Could you share a screenshot of your table with some example data please?


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

        Terms & ConditionsAccessibility statement