Returning a symbol value for parent-child relationship across smartsheets
I have two sheets. One provides information for each project by the project vendor, the other links a project to it's multiple vendors. In the second sheet, I want to pull over the project at with at risk TAT status symbol for that project, so I can see across vendors the total project risk.
Here is Sheet 1 (summarises data at the Vendor level). Each vendor has several dependent child projects.
Here is Sheet 2, which Project level data across vendors. I've highlighted the ones that have a matching sheet 1 risk symbol, I would like to automatically pull through, if there is a match to sheet 1 project listed for the child vendor.
Can you help me with this, I've been trying to solve for it, and I just can't get anywhere, and am pretty sure it can be done, I just haven't cracked how.
Help Article Resources
Check out the Formula Handbook template!