Join Formula, bringing data from one sheet to another for Procurement use

Kyle Campbell

Hello, I'm new to Smart Sheets and I'm trying to navigate myself through this new world.

Long story short, I'm building a procurement system from the ground up for my current company. I've created an RFQ sheet / Workplace, I've figured out how to let my team fill out forums to populate rows and used Document builder to create a RFQ template to send to vendors.

I'm now trying to make the automation continue, I want my team to check "Send for RFQ" when that happens I want the document we generated to send to our Vendor contacts under certain commodities. In order for that to happen I need the correct vendors to be selected based on the commodity selected for said RFQ..

I would like the "email" to be transferred over to my sheet IF the commodity group and location meet the criteria. So when my team selects "safety" in Commodity Group and "TEST" for location it will populate how ever many vendors fit said criteria in my "Contact Email" column.

The two screen shots are from different sheets

The sheet with "Contact Email" also has Commodity Group included if that helps

Paul Newcome

You would use a JOIN/COLLECT along the lines of

=JOIN(COLLECT({Email Column}, {Commodity Column}, @cell = [Commodity Group]@row, {Location Column}, @cell = Location@row), "; ")

Paul Newcome

You would use a JOIN/COLLECT along the lines of

=JOIN(COLLECT({Email Column}, {Commodity Column}, @cell = [Commodity Group]@row, {Location Column}, @cell = Location@row), "; ")

Kyle Campbell

Paul! you're a life saver.

Thank you so much !

Paul Newcome

Happy to help. 👍️