locked
Status indicator in Document Library RRS feed

  • 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

    Thursday, February 16, 2012 6:10 AM

Answers

  • 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.
    Document_status_indicator


    Murugesa Pandian.,MCTS|App.Devleopment|Configure


    Thursday, February 16, 2012 7:42 AM

All replies

  • 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

    Thursday, February 16, 2012 6:40 AM
  • 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.
    Document_status_indicator


    Murugesa Pandian.,MCTS|App.Devleopment|Configure


    Thursday, February 16, 2012 7:42 AM
  • 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

    Thursday, February 16, 2012 7:58 AM
  • 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

    Thursday, February 16, 2012 8:20 AM
  • =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


    Thursday, February 16, 2012 9:30 AM