Beast Mode: Dependency Identification
I am trying to do a dependency status table for the project lifecycle.
I currently have columns for Project name, associated Project Status, and Dependent Project (which other project is required for this one to complete).
I am trying to write a statement to insert another column that identifies the status of the dependant project - so it will refer to column 2 to find the status of the project with the same name as the dependent project. I have given an example table below; Project C has status Green so it's good to go ahead, BUT depends on Project B to complete which is in Amber so it cannot go ahead yet.
|Project name||Project Status||Dependent Project||Dependent Project Status|
- 7.3K All Categories
- 13 Getting Started in the Community
- 142 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 904 Connectors
- 237 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部