Thanks @Jeff_Hager! Very helpful. Can you think of some way to help me with glide native solution as well. I know you can! I tried for 3 hours and didn’t get anywhere.
Here is the problem rephrased:
There are text only columns which contain target text. I need glide to identify one part per column and these columns should make an array so that I can create and inline list.
Previously, I had created Boolean columns in sheets that I would manually ‘switch on’/ mark ‘TRUE’ so that another column in an array would write the keyword leading to a relation and thus leading to an inline list in glide. I am trying to avoid the manual ‘switch on’ using sheets.
If you can’t think of a solution, I understand and thank you for thinking.
If I am not clear in explaining the problem, please let me know.