I am creating a task report to enable project owners to bulk update task statuses and I need a column on the report that shows what the next task on the applicable project is.
I am not looking for the next ready to start task - what I need is for the project owners to be able to see what the next task up is going to be before they mark the existing open task as complete. The report is already pulling in just the current ready to start task on a set of projects.
I am assuming that this would be a text mode field but I'm not having any luck figuring out the syntax I need.