how to filter out blank fields in Gen3 - using Task Time, Expense, Cost & Billing data template

  • 1
  • Idea
  • Updated 5 years ago
  • Not Planned
in Gen2 - you had a filter to only show tasks with time entries - this appears to be gone in Gen3
Photo of ScottBunnett

ScottBunnett

  • 3 Posts
  • 1 Reply Like

Posted 5 years ago

  • 1
Photo of Lingaraj Dharwad

Lingaraj Dharwad, Product Champion

  • 1100 Posts
  • 46 Reply Likes
Hi Scott,

Thank you for using Replicon community,

Currently, you can use the work schedule template under the timesheet category, which shows only the data entered on the timesheet. Unlike Gen2 there isn't a filter right now to show only task with time entries. I am marking this as an idea and are reviewing the same.

Thanks,
Lingaraj
Photo of ScottBunnett

ScottBunnett

  • 3 Posts
  • 1 Reply Like
no that doesn't work - as you don't have access to project/task related fields.
Photo of ScottBunnett

ScottBunnett

  • 3 Posts
  • 1 Reply Like
we have found a solution
Simply add the filter “Timesheet Period” If you want to report for the entire project, specify the start and end dates as “< None >”
Photo of Lingaraj Dharwad

Lingaraj Dharwad, Product Champion

  • 1100 Posts
  • 46 Reply Likes
Hi Scott,

Thank you for sharing this with the community.

Regards,
Lingaraj
Photo of Naveen Chander

Naveen Chander, Product Manager

  • 39 Posts
  • 12 Reply Likes
Official Response
Hi Scott,

Thank you for posting. That is a great solution.

I'd like to add an additional point - The Task Time, Expense, Cost & Billing data template is designed to show both Time and Expense entries logged against Tasks. So, we could alternatively use the 'Approval Status' filter (with all Statuses selected) which will cause the report to show both Time and Expenses entries without the other blank entries. 

Apart from that, we will review the requirement of an additional filter to show only Tasks that have actual entries, in future product planning sessions.

Thanks,
Naveen 
(Edited)