List all At Risk Items and their Dependencies
Hi all,
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.
Answers
-
A report would be the easiest way to display all At Risk Items that would also be viewable on a Dashboard.
Regarding dependancies and what you want to do, it may vary regarding if those dependancies are children of the row, or if that's dependancies in the Gantt view.
Could you post a few screenshot with dummy data of what you want to do here?
-
Yes, we have the At Risk items in a report, but our dependencies are all over the place, so may not be child dependencies. For instance, We may have an item in a marketing workstream that is dependent on an IT workstream item.
Ideally, I'd love to display the connected dependencies from the Gantt. Screenshots could work, but I need to pair down the data as this manager doesn't want to see all the other data in the grid. It's complicated.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!