Skip to main content
Solved

Using IF and FIND in a formula

A

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" )

 

 

View original

    TheTimeSavingCo
    Forum|alt.badge.img+18

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

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

     

     

    Adam, Consultant @ The Time Saving Co
    A
    • amykalra
    • Participating Frequently
    • January 18, 2023
    TheTimeSavingCo wrote:

    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+18
    amykalra wrote:

    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, Consultant @ The Time Saving Co
    A
    • amykalra
    • Participating Frequently
    • January 20, 2023
    TheTimeSavingCo wrote:

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

    Reply


    Terms & Conditions