Sorting a column in my table without changing the data

[Tiger1]

I am trying to sort a column in my table:

Table - “Customers”
Column - “Customer_Name”

All i want is the column “Customer_Name” to be in ascending order by name.

I have tried using SORT().
I tried ORDERBY

I tried putting the formulas in “Valid_IF” and “Formula”

I am at a loss. Any help would be greatly appreciated.

Thanks

[Steve]

Row sorting in a table view is controlled exclusively by the column sort order indicated in the view configuration itself:

[Tiger1]

Sorry. The table “Customers” is referenced by another table “Ticket log”. Inside the ticket lo - i have the column “customer Name” - which comes from that table.

So basically it is a referenced column that i need sorted. I cannot sort it how you showed. It is not a table VIEW. i use it in a form (dropdown menu)

[Steve]

Ah, sorry I misinterpreted your problem. Have you seen this?

help.appsheet.com

Dropdown on a Ref Column

How to limit which values appear in your dropdown when updating a Ref column.

[Tiger1]

Thanks. But i dont want to filter out anything. I am sorry i am not explaining this very well.

I have two tables - “Customers” and “Ticket Log”.

Customers table has “Customer_Code” - the key and “Customer_Name” - the Label

Ticket Log table has “Customer key” - reference to “Customers” table and “Customer” - [Customer key[.[customer_name].

I need the Column “Customer” from the Ticket Log Table - to list all those reference names customers in ascending order.

[Steve]

The doc I referenced above is relevant. You should read it.

Set the Valid If expression for the Customer key column of the Ticket Log table to:

ORDERBY(Customers[Customer_Code], [Customer_Name], FALSE)

[Tiger1 · Accepted solution]

WORKED PERFECTLY. Thanks so much Steve!