Skip to main content

Trying to do the following in my base: if field a = X, field b = X and field c = X or blank. Result will be pass, fail.



For more detail X = approved.



What is the current function?

Welcome to the community, @Maria_Rekhels! :grinning_face_with_big_eyes: If I understand your setup correctly, this should work (spread across several lines for clarity):



AND(


    {Field A} = "Approved",


    {Field B} = "Approved",


    OR(


        {Field C} = "Approved",


        NOT({Field C})


    )


)


That will output a 1 or 0: 1 if all conditions are met as described, 0 otherwise. If you literally want the text output to be “Pass” or “Fail”, use this:



IF(


    AND(


        {Field A} = "Approved",


        {Field B} = "Approved",


        OR(


            {Field C} = "Approved",


            NOT({Field C})


        )


    ),


    "Pass",


    "Fail"


)

Reply


Terms & Conditions