I Have a workflow that sends email to one column. I need to send emails to next column when the first column is blank.
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