Email Query

[Jules22]

I Have a workflow that sends email to one column. I need to send emails to next column when the first column is blank.

[alexnajm]

Use a Formula beforehand to fill in that first column with the second column when the first is empty! Something like:

IF IsEmpty([Email1]) THEN [Email2] ELSE [Email1] ENDIF