Skip to main content

Vote (0) Share
's profile image

on

Comments (0)
's profile image Profile Picture

Sonali Gupta on 09 Feb 2022 06:21:44

RE:

Hi, It will be great to have this feature indeed. As a workaround I use the custom conditional columns.You insert a new conditional column in the data table (I called it order by) Assign a number for each value in the desired column(column A) for which you want to assign the custom order. If you have 10 values you want to put in specific order you use the number from 1 to 10.Make sure your new column is with data type Number. Then close & apply the changes,Select the column (Column A) to which you want to apply custom order,Once you select the (Column A) on the top new tab Column tools will appear Select sort by and select the new column with the assigned number for the values in your column It works well for me as a workaround to sort and order everything the way I want to. The downside is that it is manually maintained.

's profile image Profile Picture

Sonali Gupta on 09 Feb 2022 05:48:47

RE:

Hi, It will be great to have this feature indeed. As a workaround I use the custom conditional columns.You insert a new conditional column in the data table (I called it order by) Assign a number for each value in the desired column(column A) for which you want to assign the custom order. If you have 10 values you want to put in specific order you use the number from 1 to 10.Make sure your new column is with data type Number. Then close & apply the changes,Select the column (Column A) to which you want to apply custom order,Once you select the (Column A) on the top new tab Column tools will appear Select sort by and select the new column with the assigned number for the values in your column It works well for me as a workaround to sort and order everything the way I want to. The downside is that it is manually maintained. 

's profile image Profile Picture

Sonali Gupta on 08 Feb 2022 12:31:21

RE:

You insert a new conditional column in the data table (I called it order by) Assign  a number for each value in the desired column(column A) for which you want to assign the custom order. If you have 10 values you want to put in specific order you use the number from  1 to 10.Make sure your new column is with data type Number. Then close & apply the changes,

's profile image Profile Picture

Sonali Gupta on 08 Feb 2022 12:16:34

RE:

test1test2

's profile image Profile Picture

Sonali Gupta on 08 Feb 2022 12:15:03

RE:

test1test2test3

's profile image Profile Picture

Sonali Gupta on 31 Jan 2022 07:23:25

RE:

testing

's profile image Profile Picture

Sonali Gupta on 31 Jan 2022 07:18:58

RE:

test

's profile image Profile Picture

Sonali Gupta on 28 Jan 2022 07:20:36

RE:

test

's profile image Profile Picture

Sonali Gupta on 11 Jan 2022 07:36:43

RE:

test

's profile image Profile Picture

Sonali Gupta on 11 Jan 2022 07:24:21

RE:

onclick=prompt(8)>