I have a table with values taken from a ggsheet.
I would like one of the columns ("materials") to be a list and, for each row, the list would change depending on the item in the column before ("Products").
The values of the list in question would be taken from another "Getmaterials" query in another ggsheet, comparing the "Products" column with the "Product Type" column of that query.
If the values of these two columns are equal, the list would return the items in the "Materials" column of the corresponding "Getmaterials" query.
I've looked into the forum, tried some stuff, but can't seem to find the right solution for this.
If anyone can help me with that, I'd appreciate it