Pull Data from Master sheet to another sheet

Miki Jeffers
Miki Jeffers ✭✭
edited 12/09/19 in Formulas and Functions


I have a master vendor list sheet that contains a checkbox column for vendor type.  I would like to create a new sheet that pulls over just the vendors that have the vendor type column checked.  I need a separate sheet so I can use it for widget in my dashboard.  I don't want to filter or sort the main master vendor list.  Does anyone have suggestions on how to go about doing this?

I appreciate any assistance.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!