Can I create one:many and many:many relationships between two SmartSheets?
I have two related SmartSheets covering different aspects of my data. I would like them to refer to each other so that I can ultimately pull certain aspects into a report. I prefer to use SmartSheet over SQL in order to take advantage of the workflow and approval capabilities.
However. I cannot figure out how to link data in the case of one:many and many:many relationships. See the example below (yellow is my desired result; blue are already linked since they are 1:1 relationships. Does anyone know if this is possible and if so, how to accomplish it?
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!