I am trying to summarize information from multiple columns within a Smartsheet to identify Columns that may or may not apply to a specific Team. Using the example below, I would like to summarize the Columns that apply to Dept 1 and Dept 2. For example, the desired outcome of the example would note that Department 1 requires Training 1, 2, and 3 while Department 2 would only require Training 2 and 3.
Is it possible to summarize and list column headers? I have explored the possibility of using a INDEX COLLECT function but not sure this is a viable solution.
Would appreciate any insights or guidance to help solve this. Thanks!
