# IF AND Formula with 2 criteria to comply

Topic Labels: Formulas
Solved
1018 2
cancel
Showing results for
Did you mean:
4 - Data Explorer

I can't get this formula to work.

My table has 3 fields:

• Agreement Signed
• WYNTK Signed
• Intake Form

Each field has a single select option, "Yes" , "n/a" or "In Progress".

I have a final field "STATUS" with a formula - should all three fields = "Yes" or "n/a" =  "

If any one of the fields = "In Progress" then the STATUS field = "

IF(
AND(
{Agreement Signed}="Yes",
{Agreement Signed}="n/a",
{WYNTK Signed}="Yes"
{WYNTK Signed}="n/a",
{Intake Form}="Yes"
{Intake Form}="n/a"
),
"",
""
)
1 Solution

Accepted Solutions
18 - Pluto

Could you try this out?

``````IF(
AND(
OR(
{Agreement Signed}="Yes",
{Agreement Signed}="n/a"
),
OR(
{WYNTK Signed}="Yes",
{WYNTK Signed}="n/a"
),
OR(
{Intake Form}="Yes",
{Intake Form}="n/a"
)
),
"✅",
"❌"
)``````
2 Replies 2
18 - Pluto

Could you try this out?

``````IF(
AND(
OR(
{Agreement Signed}="Yes",
{Agreement Signed}="n/a"
),
OR(
{WYNTK Signed}="Yes",
{WYNTK Signed}="n/a"
),
OR(
{Intake Form}="Yes",
{Intake Form}="n/a"
)
),
"✅",
"❌"
)``````
4 - Data Explorer

@TheTimeSavingCo Worked! Thank you so much! 🎉