Skip to main content
Solved

IF AND Statement

  • October 19, 2022
  • 4 replies
  • 607 views
Z
Forum|alt.badge.img+4

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

Best answer by Nathaniel_Grano

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

4 replies

N
Forum|alt.badge.img+13

Hi @Zak_Kennedy ,

Try this formula

IF(
  AND(
    {Problem Category},
    NOT({Closed Date})
  ),
  "Marketable",
  "Problem"
)
Z
Forum|alt.badge.img+4
  • Zak_Kennedy
  • Author
  • Participating Frequently
  • October 19, 2022

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.

N
Forum|alt.badge.img+13

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"
  )
)
Z
Z
Forum|alt.badge.img+4
  • Zak_Kennedy
  • Author
  • Participating Frequently
  • October 19, 2022

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