Help

IF AND Formula with 2 criteria to comply

Topic Labels: Formulas
Solved
Jump to Solution
663 2
cancel
Showing results for 
Search instead for 
Did you mean: 
JoVanEeden
4 - Data Explorer
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
TheTimeSavingCo
17 - Neptune
17 - Neptune

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

See Solution in Thread

2 Replies 2
TheTimeSavingCo
17 - Neptune
17 - Neptune

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

@TheTimeSavingCo Worked! Thank you so much! 🎉