Skip to Content
Nov 30, 2022 at 03:18 PM

nested formula



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