none
Cacluating Defect Age on Sharepoint

    Frage

  • Hi All

    After reading numerous threads where everybody explained calculating age of a record or DOB etc

    My Query is related to typical defect age rule

    Suppose i have 5 defects (consider these are records/rows created on SP)

    All raised 2 days before

    4 are having status = Closed

    1 is till Open

    I need a field which can show based on the above details where

    if Defect is Closed then Closed date minus created date

    else today minus created date

    What formula i can use on SP?

    Freitag, 22. Juni 2012 09:54

Alle Antworten