Date calc based on other field value
That seems to work fine, but it gives me the current date as of 12AM. I'd like the current date and current time. Can you advise on how to do differently in steps 5 & 6? Thanks!Dave Englund
July 2nd, 2011 9:52am
I want my “End Dte” date field to be automatically updated when someone selects the “Done!” option value from the “Status” multiple choice list. So, I am trying to enter
a calculated value for the “End Dte” field, something like:
=IF([Status]=3,”",[End Dte]=[Today]
But, thus far SharePoint doesn't like it. Can anyone help?
Dave Englund
Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2011 2:08pm
Hi ,
I understand that you want to set the End Dte column value based on the status of the item .You can achieve this by using SharePoint Designer .
1.
Open the site in SharePoint Designer .
2.
Choose File>New>Workflow .Specify the list which the workflow is attached to .
3.
Choose all the three start options .Click next.
4.
Click on the Conditions and choose Compare list field .Set the filed as Status and set the value as ‘Done’ .
5.
Choose ‘Update list Items ’ in the Actions field .Set the list as current item .Add the field End Dte to the value Current Date .
6.
Click OK to save the workflow .
If you have any more questions ,please feel free to ask .
Thanks ,Entan Ming
July 3rd, 2011 4:14am


