List all At Risk Items and their Dependencies
I have an ask from a manager who would like to see a quick view that shows not only At Risk items, but also all dependencies that would be affected if these at Risk items are not handled. I already have the formula to get the At Risk items displayed. But I am drawing a blank on how to show all these dependencies. If they were all the same workstream, I could maybe do it that way, but something in Marketing may affect something in Production and so on.
I want to create a view on our main dashboard to show this but I am coming up blank on how to get this to appear.