Adding email list for Automations

Hi All,

I have a Drawings Sheet that I use to update contractors with up to date drawings, I send them a simple published URL but do not share the sheet with them. (See below)

I use another Project Sheet to run the project and keep a status of the jobs. In this lists all the contractors with a Purchase Order for the works etc. (See below)

What I want to do is grab the contacts from the Project Sheet with their status set to 'PO Sent' as an email list for the automation on the Drawings Sheet.

Is there an easy way to automate this information from one sheet to another?

I hope this makes sense,


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!