Index/Match on Checkbox

I have two sheets,

1- Stakeholder matrix with contact information and checkbox for primary contact

2- Project plan

I need to pull the email address's from Sheet 1 that have been "checked" as primary into sheet 2


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!