Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IF(ISNULL(ClosedDate),Now()- CreatedDate , ClosedDate - CreatedDate)
- IF(AND(TEXT(myReason) == 'A', TEXT(myDesc)== 'Item1'), 10080, IF(AND(TEXT(myReason) == 'B', TEXT(myDesc)== 'Item2'), 10080,IF(AND(TEXT(myReason) == 'A', TEXT(myDesc)== 'Item3'), 1440,(this goes on for 200 items)
Add Comment
Please, Sign In to add comment