Master Schedule 'delayed' calculation

I have a 'delayed' column to calculate the number of days delayed for a specific task and use that to create a table of delayed tasks on my dashboard. The calculation works BUT it also includes any subsequent tasks that have the initial delayed task as a predecessor. How can I filter the report which displays the delayed table so it only displays the initial delayed task and not all of the subsequent 'tied' tasks? It is creating a view of MANY delayed tasks which can't even be started until the initial delayed task is complete and I would prefer if only the initial task were listed.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!