I have a SharePoint (2013) list. I want to create a Nintex workflow (2013) that if the Status column changes to 'Closed' from any other status, then add a 'Closed Date'. If the 'Status' column is already set to 'Closed', DO NOT change the 'Closed Date'. How can I set the logic up to do this?
Solved! Go to Solution.
In your Workflow-Settings you configure your workflow to start on item modified - conditional. In the conditions you can access your status field and check if it's "Closed". You can also check for the previous value of that column to see if it was not "Closed".
and - I MAY have gotten this to work. I removed the start-up condition they had for Add. I left the start-up condition for Modify. Then I simply added the 'Set field value' and set 'Closed Date' = current date. No need to do an if statement or anything since it will get in the workflow on the right condition. I'm waiting on the user who wanted me to fix it to see if that will work for them. I think I was making this harder than it needed to be. I'll keep you updated.
I suppose this issue has been resolved?
Another thing i wanted to add. Working with dates and checking if it's empty is a bit tricky. You can also check if a date is smaller than a certain date (we use 01/01/2000)
An empty date may equal the dates 01/01/0001 or 01/01/1900 (there is a logic to this, but i'm not fully certain i've found it yet)