Is there a Formula (Set of Formulas) that can check multiple dropdowns from other data column?
I have a Metrics sheet in which I'm trying to populate a dropdown list (multiple values) with building types from client portfolios.
As an example Client A could have 5 buildings: 3 Office, 1 Industrial, and 1 Warehouse; Client B has only 5 buildings as well: but all are Office. The client buildings are in a sheet with all of their basic details listed out in rows per building. I want to populate a dropdown list in a metrics sheet with the distinct building types that a client has within the primary data sheet.
In the example above Client A should have "Office"; "Industrial", and "Warehouse" selected in the metrics dropdown list whereas Client B would only have "Office". I want that to be populated by a formula but so far all that I've been able to use is JOIN(DISTINCT(COLLECT))) which works but it changes from a dropdown to a running text list which isn't ideal.
Thanks in advance,
Help Article Resources
Check out the Formula Handbook template!