Cacluating Defect Age on Sharepoint
-
Freitag, 22. Juni 2012 09:54
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?
.png)
.png)
