Hello everyone. Hoping for assistance. We have multiple projects that each have a workplan and action log. In order to keep life simple, I have created a consolidated report that pulls tasks across all the projects (from the workplans and action logs) for each team member as many team members are attached to multiple projects. That way, they don't have to jump around to see all the tasks that are attached to them. However, to support the team, I also want to send status update requests when the tasks are past due to twig them to either change the due date or mark as completed as often tasks are completed, they just aren't updating the workplan/logs. I have an automated status update reminder going out for a general action log for the team which they like as it makes it easy to keep things updated; they would like the same but as one email/week (so just replacing the one that goes out for the 1xgeneral log, with a consolidated one for all the project tasks). It doesn't look like I can perform this function from the consolidated report and I don't want to set up this automated workflow for all the individual workplans and action logs as some people will be getting 10+ status update requests given the number of workplans/action logs that their name is attached to. Any suggestions from people who have solved this problem?
