I understand you are a busy man, but if you can spare atleast sometime to my query below then I will really appreciate the gesture.
We get several requests (items on SharePoint list) on a daily basis. We assign different request status to different requests. We need to track ageing of a request in a particular request.
How long has the request being in a particular status?
We have column called ‘Request Status’. If this column value for an item is say 'XYZ', then I need to check for the column ‘Modified’. This modified column is a sharepoint default which shows last modified date.
Now, I will compare this column ‘Modified’ with today’s date and do following:
- Have a calculated column ‘Ageing’ which will calculate for each request (item on SharePoint) its age since its last modified date(in days). Based on this ageing date different traffic signal lights will be shown in this column.
So, if ageing date is
0-1 days: Green Light
1-2 days: Amber Light
Beyond 2 days: Red Light
Limitations: 1. Implementation will be inside company intranet and hence Sharepoint Designer does not work. Only way is Content Editor Web parts through scripts.
I am very new to Sharepoint thingy. Gone through several solutions suggested in various sites like paths.to-sharepoint but alas couldnt customize them to what I was looking and it didnt work. Most of these were 'countdown' and hence had to customize which I couldnt do.
I have entries of a list grouped by, so it should work with this arrangement.
Any help from anyone will be very much appreciated as I need to implement this solution as soon as possible.