I am trying to do conditional formatting but I have two values that need to be the condition and for whatever reason I cannot figure out the formula for an empty Field I know this is simple and yet it eludes me. For instance I have the current formula of
ServiceTickets::INVOICE# = "False" & ServiceTickets::STATUS = "Complete"
I know the "False" is Wrong. What do I put there so that if Field ServiceTickets::INVOICE# is empty and ServiceTickets::STATUS = "Complete" Then I want the condition I set to occur?
I get stuck on the easy things thank you so much for being here I do not know what I would do without this resource.
Logical operators are AND, OR, NOT, etc. - not concatenate ('&').
-> Try AND instead of &
The isEmpty() - function should help