Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

IF AND Statement

Topic Labels: Formulas
Solved
Jump to Solution
113 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Solution

Accepted Solutions

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

See Solution in Thread

4 Replies 4

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.

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!