I KNOW this is a silly one.... I have a field for email address (Email). If email address is missing from a record, I want another field (EmailMissing) to populate with "NEED EMAIL ADDRESS".
I've tried to use Case, If isempty, etc., and it will not populate on existing records.
When I enter a new record, it populates with the "NEED EMAIL ADDRESS" but after an email address is entered, it doesn't go away.
Seems like this should be a simple one...