My question is similar to this post.
I just want my workflow to send an email when the "project lead" field changes. I currently have a workflow that fires once when the item is created, simply waiting for the field to contain a value, then sending the email.
How in the world can i get this to work? I've tried creating workflow variables, but haven't had any success. Do I need multiple workflows? An additional column in my list? that seems unnecessary.
This should just be one simple workflow that runs whenever an item is created or changed - monitoring the "project lead".
I can't get the logic straight. pretty frustrating. any help is appreciated.