Filtering Columns in Reports

I have a master sheet which has data pertaining to different departments. From this master sheet, I'd like to show only the information relevant to a department to that department, and none of the other data.

1) How do I restrict the datas in the columns that have to be shown

2) If out of 4 child rows, 3 pertain to one department and 1 pertains to another, how do i only show them the relevant information


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!