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!

Reply


Terms & Conditions