Thursday, October 25, 2018

Search for Number of Hours before the Case Is Set to Closed

Solution:
  1. Navigate to List> Search> Saved Searches> New> Case
  2. Under Criteria subtab > Standard sublist, add the following:
    Stage = Closed         
  3. In the Results tab, add the following:
    Field = Number
    Field = Date Created
    Field = Date Closed 
    Field = Formula Numeric || Formula Column = ROUND(({closed}-{createddate})*24,2)
  4. Enter Search Title 
  5. Click Save & Run button

No comments:

Post a Comment