Elapsed time of a status in a list
I'm organizing a SharePoint site for an organisation in The Netherlands. More specifically for the department Functional Management of that organisation. They receive requests from the business for maintenance and service of their business applications. These requests are being collected in a task list on a sharepoint site. In that list there are a few collums wich holds information of a specific item(request). Among others there is the collum <status>, wich indicates the status of that item. There are the following statuses: <approved> , <in progress> , <resolved> or <closed>. Some users would like to know ,for example, for how long a request the status <in progress> had. Or how much time there was between the status <approved> and <closed>. Is this possible without the use of SharePoint designer on a MOSS 2007 site? Additional info: Permissions: full control rights SharePoint Designer: no Version: Microsoft SharePoint Server 2007
August 10th, 2011 10:13am

You can write a custom event handler to capture the status change on item updating event and store the timestamp in the list. If you do want to involve SPD /Custom code, you can do it this way - Create 4 new columns for each status (eg: Approved Date, In Progress Date...etc)- make them calculated columns with return data type - date and time or date only and add the below formula for each column =IF([Status]="approved",Modified,"") replace [Status] with the title of the column that lists the 4 statuses replace 'approved' with statuses - in progress, resolved & closed Modified is the OOB Modified column that is seen in the list. For each item there will be 4 columns to represent the timestamp for respective status changes.For eg: If the current status is 'approved', only 'Approved Date' column will have a time stamp and all other columns we created will have blank values. This way you can track the status change and calculate the duration between 2 statuses based on the column values. Hope this helps Thanks, GeeVed
Free Windows Admin Tool Kit Click here and download it now
August 10th, 2011 2:22pm

Thanks for your reply. Isn't there any other way for this to work, because SPD isn't available to me.
August 11th, 2011 9:57am

Thanks for your reply. Isn't there any other way for this to work, because SPD isn't available to me.
Free Windows Admin Tool Kit Click here and download it now
August 11th, 2011 9:57am

The method I suggested can be done via sharepoint UI and does not need SPD. Since you have full control you should be able to goto the List settings from the menu bar on the top of the tasks list and hit-settings ->list settings and create new columns. Let me know if you have trouble finding something.Thanks, GeeVed
August 11th, 2011 11:04am

The method I suggested can be done via sharepoint UI and does not need SPD. Since you have full control you should be able to goto the List settings from the menu bar on the top of the tasks list and hit-settings ->list settings and create new columns. Let me know if you have trouble finding something.Thanks, GeeVed
Free Windows Admin Tool Kit Click here and download it now
August 11th, 2011 11:04am

Hi GeeVed, I tried to follow your suggestion above. Made 4 columns, I could see the date in the column when the status was approved, but the problem is, when the status changes to "In Process", the In Process column shows a date but the "Approved" column is now empty. I guess you already know of this. But is there any way, we can make the value in Approved column stay? Please let me know Thanks in advance. Roulph
September 3rd, 2012 5:19pm

Hi GeeVed, I tried to follow your suggestion above. Made 4 columns, I could see the date in the column when the status was approved, but the problem is, when the status changes to "In Process", the In Process column shows a date but the "Approved" column is now empty. I guess you already know of this. But is there any way, we can make the value in Approved column stay? Please let me know Thanks in advance. Roulph
Free Windows Admin Tool Kit Click here and download it now
September 3rd, 2012 5:34pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics