IF AND Formula with 2 criteria to comply

Question

I can't get this formula to work.My table has 3 fields:Agreement SignedWYNTK SignedIntake FormEach 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" =  "&#9989;" If any one of the fields = "In Progress" then the STATUS field = "&#10060;"   IF(   AND(     {Agreement Signed}="Yes",     {Agreement Signed}="n/a",     {WYNTK Signed}="Yes"     {WYNTK Signed}="n/a",     {Intake Form}="Yes"     {Intake Form}="n/a"   ),   "&#9989;",   "&#10060;")

TheTimeSavingCo · Accepted Answer

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"    )   ),   "&#9989;",   "&#10060;")

JoVanEeden · Answer

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"    )   ),   "&#9989;",   "&#10060;")@TheTimeSavingCo Worked! Thank you so much! &#127881;

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded