Status indicator in Document Library

Question

Hi

How to add  status indicator colum to document library? based on the expire date i need to show status indicator in the document library.

 Thanks in Advance

---

Praveen

Answer 1

hi Praveen,

Refer below :

http://office.microsoft.com/en-us/sharepoint-server-help/getting-started-with-sharepoint-status-indicators-HA010380634.aspx

Answer 2

Thanks for your reply

But i need to add a column called expiry status in document library in that i need to show that status indicator

---

Praveen

Answer 3

Hi Praveen,

Create one SitePage and place your "Document Library" webpart.[XsltWebPart].Better  to use the "WebPart Page"
Select the expire date row with data.
Right click and choose the "Contional Formating" ->Create ->Apply Formating.

Now on Conditional Criteria dialog box apply the condition

I check the Expire Date is not equal to current date then "Green" else "Red".

You can place image also that representing the Status Indicator.

---

Murugesa Pandian.,MCTS|App.Devleopment|Configure

Answer 4

Thanks for your reply Murugesa Pandian

My Document Library name is "XYZ" in that i have a existing cloumn called "Expiry Date" now i need to create a new cloumn with name of "status"

From Current Date to Expiry Date  = 60 days means i need to show Green colour (or)

Current Date to Expiry Date  between 59-31 i need to show yellow colour

Current Date to Expiry Date  between 30-0 i need to show Red colour

---

Praveen

Answer 5

Create the calculated colum "NoOfDay" use the formula to get days

=DATEDIF([ExpireDate], [CurrentDate or your requirement date],"d")

This will return the days in the NoOfDay column.
Now use the "Condtional Formating" through SPDesigner.Create three condition as per your business logic and set the "Color" or "Image".

---

Murugesa Pandian.,MCTS|App.Devleopment|Configure

Answer 6

=DATEDIF([Expire Date],[CurrentDate],"d") am using this formula current date is not working it showing error

30/Dec/1988 current date is showing like this

---

Praveen