I am fairly new to SP as well as workflows and was looking for some help.
I have a list that contains a series of columns that we are using to track an employees hiring process. As part of this process, I would like to setup a workflow that will notify that person's supervisor when HR has given the employee an 'effective hire date'
The workflow would look like this:
New record created --> If employee has an effective hire date then email their supervisor --> if not, wait until they have an effective hire date then email their supervisor.
I created a calculated value column using the =ISBLANK formula with the column name effective hire date as it's value. When I look at the column on the list it does exactly what it's supposed to. If column 'Effective hire date' has a date it returns "No", if it does not, it returns "Yes".
When I design my workflow in SP13 Designer however, it is not sending out the email as it is supposed to. I have tried a million different combinations to no avail. Here is the most basic one I created which I believed would achieve my goals:
Stage:Stage 1 Wait for EffectiveHireDateCalc to equal No then Email Current Item:Supervisor1 Transition to stage Go to End of Workflow
I have also tried it with "If" statements
If Current Item:EffectiveHireDateCalc equals No then Email Current Item:Supervisor1
All of these contained statements telling the workflow to go back to stage 1 if EffectiveHireDateCalc to equal Yes
But still NOTHING!
Like I said, I a am fairly new at this so any help you can provide would be appreciated!
Thanks in andvance