Sorting - Arranging contents of column

Is there a Formula to arrange contents of column in custom way (my choosing).

UX/SORT BY ( Ascending / Descending )
Will arrange alphabetical, numbers, date, latest entry. This is not the arrangement I want.

Hello,
I think you can add a column, and sort by this column.

image

3 Likes

@Chengzhi-EXT_GUO

Thank you for your idea.

This method is unpractical in my case.
Example: One Item has 34 records. I have to add Number ( 1 ) to each of these records in the row ( LIVE ). This applies to all rows.

SORT

I am looking for a formula.

Hi @UNITED_SKATEBOARDS
You could also try
1-Live
2-Coming soon
3 …

2 Likes

Understood, you group the row by the value “Live”, “Coming Soon”…

and you want to sort the group, as I know, user can not add the related formula in this place.
image

For me, I will change the Live to 1-Live, same as the reply of @Lynn.

1 Like

@Lynn @Chengzhi-EXT_GUO

I tried those methods before and they work perfect.

But I was looking for an easier/ shorter method. Maybe some formula can do this.

e.g. from my head:

Arranging ( Store[Status],list("LIVE","COMING SOON","PAUSED","ITEMS OUT SOUQ","SOLD OUT","BAD QUALITY")) #requests

Especially since I have a lot of previously entered records (data) .

Thank you all

Not possible. The options presented by others are what you’ll have to work with.

2 Likes

@Steve

Thank you :slight_smile:

1 Like

I found another way to arrange the contents of column, in a custom way (based on my choice):

A- I changed the type of data in column [STATUS] into ENUM
B- I added the values in the order that I wanted inside TYPE DETAILS.

C- Then I go to UX/ GROUP BY and sorted the column [STATUS] as ASCENDING.

D- The desired result is achieved.

3 Likes

Outstanding!

1 Like