Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How can I exclude a task(s) from my report if the predecessor for that task is not complete?
I have a dozen or so proejcts each with their own sheet. I've created a simple report that looks at each project and returns tasks that meet two criteria:
1. The task has not been marked complete
2. The task has a due date of 5 days or less.
This report works fine, but it returns more data than I want to report on. Specifically, it reports on tasks that are dependent on other tasks being completed. I only want to report on the first task (earliest due date) in a chain of dependent tasks.