Help

Adding the blank function to a formula

Topic Labels: Formulas
281 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Maria_Rekhels
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1

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