IF AND Statement

[Zak_Kennedy]

I am trying to create and if and statement for one field being empty and the other being filled.

My fields
Problem Category
Closed Date

Closed date always needs to be filled for me to provide a return to my field Charge Type. If the problem category is blank then I need to return “Marketable”. If the problem category is filled then I need to return “Problem”.

I have tried multiple If And statements always getting an error or undesirable result. The latest one I have gotten is as follows
If (And( Problem Category = BLANK(), Closed Date != BLANK()), “Marketable”, “Problem”)

[Nathaniel_Grano]

Hi @Zak_Kennedy ,

Try this formula

IF(
  AND(
    {Problem Category},
    NOT({Closed Date})
  ),
  "Marketable",
  "Problem"
)

[Zak_Kennedy]

Nathaniel_Granor:

IF(
  AND(
    {Problem Category},
    NOT({Closed Date})
  ),
  "Marketable",
  "Problem"
)

Thanks Nathaniel
This made everything a “problem” for the field charge type. I want to try to keep the charge type empty until the “Closed Date” is populated.

[Nathaniel_Grano · Accepted solution]

Ah, I misunderstood from your original example. Then I think you want:

• Closed date empty => empty
• Closed date filled but category empty => Problem
• Closed date and category filled => Marketable

IF(
  {Closed Date},
  IF({Problem Category},
    "Marketable",
    "Problem"
  )
)

[Zak_Kennedy]

This works. Thank you so much!