Reference to Multiple Rows



I have a sheet containing many invoices and each having a particular expense category.

In another sheet I have a Work Breakdown Structure with these expense categories. In one column I get total of each expense categories invoices by SUMIF function but I want to access all the invoices that makes up this sum from the WBS sheet item details. Like maybe in one column I see all the invoices list that corresponds to this expense category.

Is it possible?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!