I feel like I'm going insane this should be extremely easy. I'm trying to make a formula email field that simply gets populated with 1 email field (primary contact) if that's in fact filled out. Otherwise, populate with the referring attorney email field value. Both are lookups from two different tables. The email field for the referring attorney lookup is the key field for that table.
For some reason QB is expecting a textlist, not text. I've tried all sorts of type conversions, as well as part/split functions (since Split is what comes up under Textlist Functions, though the email field would never have more than a single value in the first place). I know this is going to be ridiculously simple in the end.
