locked
Elapsed time of a status in a list RRS feed

  • Question

  • 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

    • Moved by Mike Walsh FIN Wednesday, August 10, 2011 2:21 PM asks for NOT using SPD so admin not customization forum (From:SharePoint - Design and Customization (pre-SharePoint 2010))
    Wednesday, August 10, 2011 2:13 PM

Answers

  • 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
    • Marked as answer by Wayne Fan Thursday, August 18, 2011 7:17 AM
    Wednesday, August 10, 2011 6:22 PM

All replies

  • 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
    • Marked as answer by Wayne Fan Thursday, August 18, 2011 7:17 AM
    Wednesday, August 10, 2011 6:22 PM
  • Thanks for your reply.
    Isn't there any other way for this to work, because SPD isn't available to me.

    Thursday, August 11, 2011 1:57 PM
  • 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
    Thursday, August 11, 2011 3:04 PM
  • 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

    Monday, September 3, 2012 9:19 PM
  • Hi Roulph,

    I am exactly in the same situation, have you found the way? kindly let me know if you have a solution.

    Many thanks,

    Vasnath

    Tuesday, April 21, 2015 11:57 AM