How do I create a Index/Match formula w/ a condition across sheets?

I have a sheet with a bunch of site location data. This sheet includes a check box column showing if the site is Open (Checked = Open).

I have another Project sheet where I want to pull in only the OPEN Sites and populate 3 columns from the Location data (Site Name, Region, & Size).

I am having a hard time finding a formula that will work to pull only the data I need across the whole sheet. I need it to pull all 19 Open records from the Location Sheet and have only been able to get it to pull the first one. In order to get it to pull the next row down I have to go into the formula and edit the Row & Column manually. I need the Project sheet to update when new locations are opened.

Please help!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!