Hello!
I have an interesting request to capture all tasks that were closed over the weekend, specifically between Friday at 6 pm ET and Monday at 8 am ET.
I think I can find a way to do this using Fusion, but I wanted to check if anyone here had an idea for creating a report in Workfront to capture this.
@suryalakhani If you are fine with creating calculated fields on all tasks then the below might work.
Add 2 calculated fields on a custom form and add that custom form to all the tasks. You can keep it Admin only so that no one else is able to see it.
1. Create a custom calculated field like 'Day' with the formula - DAYOFWEEK({actualCompletionDate})
2. Create a custom calculated field like 'Hour' with the formula - HOUR({actualCompletionDate})
Once the custom fields are created and the custom form is added to all the tasks then create a task report with a filters for days 5,6,7,1 and Hours as needed. Note that DAYOFWEEK will out 1 as Sunday and 7 as Saturday. This should get you what you are looking for.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.