IF formula question with an empty value in column

[anitamarie2020]

Hi All, 

I just had a question on an if Statement for the below if anyone has come across one. 

If the cell in client is blank to use the cell in column A (Person) . I've tried a few and they just don't seem to work 

Thank you in advance 

Anita

[Kenda]

Hi @anitamarie2020 

Have you tried the isempty() function in your if statement? 

[anitamarie2020]

I have - not sure if I have the wrong formula in for it

[Kenda]

Can you provide the expression you have tried so that we can see where it may need to be modified? 

[anitamarie2020]

IF (IsEmpty([Client ])) then [Person ] ENDIF

[Kenda · Accepted solution]

I see. Thanks for providing that! The structure of an if statement in Alteryx is as follows:

IF c THEN t ELSE f ENDIF

It looks like you're just missing the "else" piece in your expression. With this, you're telling Alteryx what to do when Client is not empty. Try adding

else [Client]

before your endif.

[nagakavyasri]

This works according to your current data: