How to bring information from multiple columns into one column?

AppSheet AppSheet Q&A
, ,
1

I’ve had to split a table containing working groups (A, B, C, D), trails (X, Y, Z), trail-secteurs (P, Q, R, S, T), trail-sections (green, blue, red) and ToDos into multiple separate columns because I want to minimise the selecting options. Not all working groups are working on the same trails and obviously every trail has different trail-secteurs and trail-sections.

Example: In working groups I select group B, which opens the trails with only the available options for group B. I select trail X and the names of the different sections of trail X appear. If I select trail secteur Q , I choose the trail section blue out of the three options. After selecting the section the ToDos appear of which I can select multiple.

I’ve had to separate everything in separate columns for that. Now I’d like to export it so that I do have only one column for working groups, trails, trail-secteur, trail-section and ToDos.

How can I do that? To only visually combine them I could use virtual columns. Though I’d like to export them as csv.

2

You can use a normal (not virtual) column to do this.

3

but then I have to create another column in the spreadsheet, haven’t I? Can I define in a “behaviour” that I only want this column (the combined) without having all the others which are the base for the combined column?

4

Yes, you’d need another column in the spreadsheet.

The base columns have to exist in some spreadsheet somewhere to accept user input.