I have the following issue: we use a SP list to send information through the steps of the process. On each step somebody adds information into the list, next person receives it, adds his own part of information and it goes to the next step and so on. We need to see the date and time when each step was done. For first and last step we see it by columns "created" and "modified" for intermediate steps we created the calculated column with following formula:
Problem is that with every new information added into the row the date&time are updated. How can I fix the date&time that it keeps only the date&time of the moment when somebody added the information in the exact column which I placed in the formula. Maybe it is possible with SP designer?
I found the following answer on a similar question for workflow but don't understand how I can apply it for a List: SharePoint Designer Workflow, set field
Thank you in advance!
Workflow try when a person chooses "Yes" in the Status column that in column "Date & Time" appears current date and time and that this time would not be changed if somebody updates the information in the string.
Finally it works this way, with the additional settings in "Date & Time" - default value "01/01/2014 0:00:00"
"Date & Time" is the text fild with default value 1