But I don’t know if categories and hierarchies is what will solve the problem, although I appreciate learning those details again.
I am looking at three sheets in particular.
1.) Project Gallery - where project related data is stored, and where I need to pull the unique list.
2.) Project Items - a glide table that acts as a catch all for users uploading individual items into the project. Has a related projectID and productID
3.) Products - a list of all the products (skus) we have. The project items are related from this sheet. Each of which, has a stone collection and relates to a separate sheet, although, I don’t think I have to go this far to achieve what I am looking for.
As a user is submitting items into the project, a list builds up in the Project Items tab with a relation to each project via a projectID.
My intention is to show all of the unique stone collections used in the project by rolling up all the values in the project items tab and filtering only the unique ones.
I thought about using lookup field to fetch all the stone collection names through the relation from the project tab to the project item tab and then, somehow filter all the repeated stone collection names, to display only the unique values.