IF Statements to Quote Different Columns

[JTB76]

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 solution]

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 🙂

[JTB76]

Awesome!  Worked a treat. Thanks for that