Hoping to be able to get Columns like this:
Project Name: Jill's Project
Next Item Due: "Send the Email to Prospects"
Next Thing Due Date: 6/5/20
Assuming you're trying to do this from within a Project report, although you can use a IF statement to detect a particular Task (e.g. by name, etc.) within a Task "iterate" column, it is not possible to aggregate (e.g. MIN, in this case), nor sort.
There's some more background here, in case it gives you an idea that you could use instead.
Well, I would cheat and use our Hot Sheet solution <grin>.
But if I had to stick to a Workfront report, I would:
@Anthony Imgrund‚ can you suggest any other improvements that I might be forgetting in order forJill to get even closer to what Hot Sheet provides?
I did the report the way you suggested -- the thing I've never used is "Minimum" so that was a good one for me. And the good news is that at the roll-up of the Project grouping it shows the planned due date of the next task due, so it actually does what I need it to!! Thanks!
As long as your project doesn't have parallel paths, you can do a Can Start filter on your task collection. Actual Date is blank (it isn't complete) and Can Start is True (or Yes haven't tried it out yet), you should get just one task as the return value.