That’s correct, and a good example!
I saw your Section 2 solution and that will work, although I’m worried about the scalability.
Is there another data format that would work better? Having the data in labeled rows and trying to use “thisRow” lookups? I didn’t go down that road yet because I figured this column select would work somehow I just wasn’t seeing.
I can sort of morph the data however ahead of time, but I’m hoping to avoid having to make a new Table/formula entry/etc. for each new list item I add. In the end the user will be able to add their own items to the list and I don’t want to make them edit a formula or know to copy and paste a whole structure to put data into (although maybe I could formify that?).
Thanks!
Peter