I am trying to create a variable to return an email address that may exist in one of three places
We have three fields for email : 'Work Email'; 'User Email'; and 'Email'. My variable should return the Work Email first.
Where there is no 'Work email', it should return the 'User email', and where there is no 'Work email' or 'User Email', it should return 'Email'.
So to clarify:
No Work Email Then User Email
No User Email Then Work Email
No User Email or Work Email Then Email
No User Email or Email Then Work Email
My current formula looks like this, but it's not quite working and I am hoping that someone is able to assist please
Many thanks in advance