Been enjoying learning Coda, although switching off Sheets/Excel logic at times can be tough.
I have a table where the Display Column is people’s names, and each column thereafter is an item they own. The last column is an aggregate which combines all the items each person owns. For example:
Using the List function, I can successfully combine the items from columns Item1, Item2, and Item 3. But, is there an easier way to select all of the “Item” columns? For example, if there were 50 Items columns, it would be tedious to individually type in the name of all corresponding columns in a List function. In Excel/Sheets, this would be akin to B:D to select such a range, but I appreciate that Coda operates on a column-based system.
I am also asking this for dynamic purposes. i.e. If I add an additional “Item” column (e.g. “Item4”), I would want that automatically added to the “AllItems” column.
Bonus points if there is a way to select all columns n places left or right of a specific column. i.e. List all the items from columns 3 to the left of this column.
Thanks in advance for any insight.