Search tasks: Search for next open task in timeline | Community
Skip to main content
KIMBERLYREA
Community Advisor
Community Advisor
October 18, 2023
Question

Search tasks: Search for next open task in timeline

  • October 18, 2023
  • 0 replies
  • 280 views

Goal:

  • Search for projects set as "With Stakeholder" status
  • see tasks that are set as "Business Review".  (Business Review 1, Business Review 2, etc)
  • Based off the planned completion date of that task, send out a series of updates on the project
    • 2 days before planned completion date
    • day of planned completion date
    • day after planned completion date 
    • 1 week after planned completion date -> switch project to status "Delay - With Stakeholder"
    • 2 week after planned completion date -> switch project to status "RePrioritization Required"
    • 3 weeks after planned completion date
    • 4 weeks after planned completion date -> Mark project as status "Cancelled"


How do I pull in Just that first task during the first round but not look at the other Business Review tasks on the project?  I want to set a reminder based of the active task. Then how do I make sure the next time it's on Business Review 2 and stuck the reminders go out? 

In the example above the dates would look like this:

  • 2 days before planned completion date
    • Update sent Oct 23rd
  • day of planned completion date
    • Update sent Oct 25th
  • day after planned completion date
    • Update sent Nov 1st
  • 1 week after planned completion date -> switch project to status "Delay - With Stakeholder"
    • Update sent Nov 8th
  • 2 week after planned completion date -> switch project to status "RePrioritization Required"
    • Update sent Nov 15th
  • 3 weeks after planned completion date
    • Update sent Nov 22nd
  • 4 weeks after planned completion date -> Mark project as status "Cancelled"
    • Update sent Nov 29th
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.