Solved: Sort values in a virtual column - Page 2

BOTFORCE · 12-30-2020 03:40 AM

Hi all,

I have table with 36 columns for body-weight and -fatt measures [Körperfettmessungen]. Below you can see only 13 columns of them.

PZ-Kinn	PZ-Wange	PZ-Brust	PZ-Trizeps	PZ-Schulterblatt	PZ-Rippe	PZ-Hüfte	PZ-Bauch	PZ-Knie	PZ-Waden	PZ-vOberschenkel	PZ-hOberschenkel	PZ-Bizeps
0,97	0,86	3,18	0,80	1,24	0,89	0,28	3,87	0,36	0,18	0,37	1,92	0,34

I want to create in this table a virtual column (called: Priority) where only these 13 columnnames need to be displayed (sorted ) from the highest value to low value.

I have tried an SORT and Select expression as I thought a mutiple column select was possible like in SQL, unfortunately not. In Sheets you can select a column range and use the LARGE() function.

How can I get in my virtual column as text with the 13 columnnames (values are not even that relevant) to display from high to low. Below is an example in Google Sheets:

Thx!
Robert

Steve

Yep. Set the virtual column’s App formula expression to:

LIST(
  [PZ-Kinn],
  [PZ-Wange],
  [PZ-Brust],
  [PZ-Trizeps],
  [PZ-Schulterblatt],
  [PZ-Rippe],
  [PZ-Hüfte],
  [PZ-Bauch],
  [PZ-Knie],
  [PZ-Waden],
  [PZ-vOberschenkel],
  [PZ-hOberschenkel],
  [PZ-Bizeps]
)

View solution in original post