(if) statement when the rows in a column are empty

[SubbuSharma]

Hi There, 

I have written a (if) statement to bring in a specific value when the rows are blank. However, I am not able to get the end result. Please see the formula & the highlighted section below.

Let me know how to go about this.

if [Review/action needed by]="Breanna" then "Client Care Investigators"
elseif [Review/action needed by]="Farah" then "Client Care Investigators"
elseif [Review/action needed by]="Muhammad" then "Client Care Investigators"
elseif [Review/action needed by]="Shaliny" then "Client Care Investigators"
elseif [Review/action needed by]="Breana" then "Client Care Investigators"
elseif [Review/action needed by]="Tammy" then "Client Care Investigators"
elseif [Review/action needed by]="N/A" then "Client Care Investigators"
elseif [Review/action needed by]="([IsNull])" then "Client Care Investigators"
elseif [Review/action needed by]="Kerry Ann" then "Compliance Officers Reviewing"
elseif [Review/action needed by]="Marilia" then "Compliance Officers Reviewing"
elseif [Review/action needed by]="Firdaus" then "Compliance Officers Reviewing"
elseif [Review/action needed by]="Trina" then "Compliance Officers Reviewing"
elseif [Review/action needed by]="Patrick" then "Compliance Officers Reviewing"
elseif [Review/action needed by]="Anu" then "Compliance Officers Reviewing"
else "New"
ENDIF

[IraWatt · Accepted solution]

Hey @SubbuSharma,

I would write the section you have highlighted as:

elseif [Review/action needed by]=Null() then "Client Care Investigators"

Or if you also want to also include blank cells:

elseif isEmpty([Review/action needed by]) then "Client Care Investigators"

Both these functions are found in the test section of the functions list:

More information on the found here Functions: Quick Reference | Alteryx Help

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[SubbuSharma]

Thank you @IraWatt , that was really helpful.

have a good one.

[IraWatt]

Great to hear @SubbuSharma, Happy Friday ! 😄