Forum Discussion

HarrisonSmith's avatar
HarrisonSmith
Qrew Trainee
6 days ago

Convert Email Lookup Key to Text

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. Othe...
formulas
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 days ago

I'm Away from my computer right at the moment on the subway, you can try this, although I didn't think it would be required this way if this does not work, can you please post your formula

 

if(ToText([Primary Matter Contact - Email]) <> "", [Primary Matter Contact - Email], [Referring Troutman Attorney (ref) - Email Text])