Post

2 followers Follow
0
Avatar

GetSumOfTimesheetReportHoursForGivenPeriod Filtering

Are there any tricks to get similar data to GetSumOfTimesheetReportHoursForGivenPeriod but with a filter?

As an example, I'd like to filter out certain projects (either by an attribute of the project or work item (like project name, project type, etc).

I read another post about doing a "Relations Summary" custom field on the User object toward Reported Timesheets.  However, it doesn't appear this could be dynamic with the date range.

 

 
Dennis Behrens Answered

Please sign in to leave a comment.

1 comment

0
Avatar

Hello Dennis,

A relations summary field should be able to this with static dates. However, you could replace static dates in the formula with custom date fields which could be updated daily by a scheduled workflow rule (i. e. dynamic dates).

Please let me know if this is helpful.

Thank you!

Roland Pumputis 0 votes