Adding the blank function to a formula

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! :smiley: 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"
)

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.