Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.

Email tool for changes in cells

Varshit
5 - Atom

I have an excel sheet where the condition I want to apply is , if the text of a certain cell is "Complete", then send the text of another cell i.e. 1001 complete as the same row as the body of the email. The sender and the receiver details also are available in the same row.

AccountStatusBody of the emailSenderReceiver
1001Complete1001 Completeabc

def

1002Incomplete1002 Incompleteabc

ghi

1003Complete1003 Completeabc

fjk

 

And assuming the status of 1002 becomes complete later, i want the email to go only to "ghi" and not to "def" and "fjk" 

0 REPLIES 0