I have 2 text fields for emails, [Email] and newer [Email Formula.] One was the original, and the second is a new text formula shortcut to input emails. To resolve this and make it easier to find emails, I've created another text formula field, which I want to set to fill with whichever of the first two email fields isn't empty. Yet the IsNull doesn't work with text formulas. I tried- "[If IsNull Email], [Email Formula], [Email])" but that won't work because an empty text field never reads as Null. So how do I get this to work?