I have a simple form that has a column for Email. I need to create a workflow notification that sends an email notification to the address listed in the [Email] Column of that form. That is done. I also need to have two other emails CC’d along with that address listed in the column. The conditional formula I am looking for would be:
IF the [Email] is the same email as one listed for the CC, don’t send a duplicate email.
Every time the user that gets CC’d submits a form, they would receive two emails. I don’t have to use a CC. I could create a new workflow to email them but only if their email didn’t = the column [Email] value. How would I write that conditional statement?