I am trying to create and if and statement for one field being empty and the other being filled.
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”)