Skip to main content

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”)

Hi @Zak_Kennedy ,

Try this formula

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

Hi @Zak_Kennedy ,

Try this formula

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.

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.


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

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

This works. Thank you so much!

Terms & ConditionsAccessibility statement