Pulling information out by business in to a new sheet



I have a large sheet where I'm tracking 7 businesses with a number of columns and metrics in each. Each of those businesses has a leader and I'd like to be able to create a sheet that would pull from the master all the information about their specific business. I can't seem to sort it out and any help would be appreciated.

Master Sheet has business A, B, C, D, E, F, G, H

I'd like a sheet that scrubs Master Sheet for business information relating to A and puts it in a sheet where I can do specific metrics for it, report status of items, comments etc. Same thing for B, C, and so on.

Master Sheet is where I work out of, the business sheets would be for reporting, some updates, etc.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!