IF Statements to Quote Different Columns

Question

Hi There.

I am sure I am making this more complicated than I need to, but its been a long Monday!  What I need to do is to say:

IsEmpty([Issue Plan ID]) = [Issue Owner Email] or !IsEmpty([Issue Plan ID]) = [Business Emails]  Endif

So, if Issue Plan ID is empty (or null) then I want to have the Email address from column 'Issue Owner Email' pulled in for everything else I want the data from Column 'Business Emails' pulled in.

Any help of any nature would be very much welcome!  Thanks all

atcodedog05 · Accepted Answer

Hi @JTB76

Your formula should be something like this.

IF IsEmpty([Issue Plan ID]) 
THEN [Issue Owner Email] 
ELSEIF !IsEmpty([Issue Plan ID]) 
THEN [Business Emails] ELSE Null() ENDIF

or simply

IF IsEmpty([Issue Plan ID]) 
THEN [Issue Owner Email] 
ELSE [Business Emails] ENDIF

You can use Mult-Field formula tool to apply on multiple columns too.

https://community.alteryx.com/t5/Interactive-Lessons/Multi-Field-Formulas/ta-p/424422

Hope this helps 🙂