1. Navigate to Lists > Search > Saved Search > New.
2. Choose Case.
3. Provide a Search Title.
4. In the Criteria tab, input the field below:
> Formula (Text) or Formula (Numeric)
-Formula: CASE WHEN {status} = 'Closed' AND {lastreopeneddate} is NULL THEN 1 ELSE 0 END
-Formula (Numeric): equal to (is)
-Value: 1
5. In the Results tab, enter fields as necessary.
6. Save & Run.
No comments:
Post a Comment