Skip to main content
Justin_Charles
Level 3
Aug 23, 2022 2:52 PM UTC
Question

Is there a way to report on tasks that are complete, but have no actual hours submitted?

I was able to create a report showing completed tasks that have 0 actual hours logged on the task.  However, if there is more than 1 person on the task and only 1 of them submits time, the other person's missing time would not populate on this report.  Is there a way to report out on Timecards that have completed tasks with missing actual hours?  Or do you have any other ideas?

 

Thanks in advance!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

8 replies

skyehansen
Adobe Champion and Community Advisor
skyehansenAdobe Champion and Community Advisor
Aug 23, 2022 2:55 PM UTC

it sounds like you would just want to use an Assignments report in the same way (with the difference being that rather than reporting on completed tasks, you're maybe reporting on completed tasks with zero actual hours per assignment (not per task)).

Translate
Justin_CharlesAuthor
Level 3
Aug 23, 2022 4:50 PM UTC

What would the column be that would show you that a user didn't enter any actual hours?  When you use Task > Actual Hours, when 1 person adds time to a task, it shows time on the task for all users on that task.

Translate
skyehansen
Adobe Champion and Community Advisor
skyehansenAdobe Champion and Community Advisor
Aug 23, 2022 5:30 PM UTC

ah, bummer! Was hoping that would work. OK I'll keep thinking.

Translate
GrahamJarrett
GrahamJarrett
Level 4
Aug 23, 2022 4:25 PM UTC

Have you thought about doing a report with collections and the column being assignments and then using an IF statement in the valueexpression to include the name as "" of the assignee if they have time but their name if the actual hours = 0

Translate
Justin_CharlesAuthor
Level 3
Aug 23, 2022 6:23 PM UTC

Graham- thanks for your reply.  Unfortunately, this terminology is a bit over my head.

 

What would the subcategory of the assignments column?

Translate
ElliotLeson
ElliotLeson
Level 3
Aug 23, 2022 5:46 PM UTC

Assignment Report

 

Translate
Justin_CharlesAuthor
Level 3
Aug 23, 2022 6:14 PM UTC

Elliot- thanks for your reply.  That is essentially what I have set up right now, but the issue with that is if 1 person submits time on a task that includes multiple people, the task falls off the report even though the other people on the task may not have submitted any time.

Translate
LindaKe
Oct 4, 2022 2:28 PM UTC

displayname=Actuals by User
listdelimiter=<div>
listmethod=nested(assignments).lists
textmode=true
type=iterate
valueexpression=CONCAT({assignedTo}.{name}," - ",({actualWorkCompleted}/60)," Hours")
valueformat=HTML

 

Insert the above to review actuals x User

Translate
Terms & ConditionsAccessibility statement

Loading footer...