Is Not Null
Hello,
I'm looking for some help using if( not is null)...
I have a field called "Seat #" and another called "Verification Cleared?."
"Verification Cleared?" is multiple-choice that can have the response of "N/A," "Approved," "Denied," or "Pending."
I'm trying to create a formula that says if "Seat #" is not null and "Verification Cleared?" = "Pending" to be called "Incomplete". Or if "Seat #" is not null and "Verification Cleared?" = any of the other options in the M/C to be called "Complete."
This is what I currently have:
ToText(If(not IsNull([Seat #]), "",
[Verification Cleared?] = "Pending",
"Incomplete",
"Complete"))
I added the "ToText" because it was giving me the yellow highlight for "Seat #" that it was expecting a date or number. When I have it as the formula I have now, it just comes out blank. The formula will work if I just have it If(IsNull), but it will still have that yellow highlight for Seat #.
What should I change to make this work? Thank you!
------------------------------
V W
------------------------------