Please help in Appsheet formula ORDER BY

[tharaka89]

Errors - Invalid input, Unable to find column

In my case CustomerID is the key column and I have put below formulas as a "valid if" to get a drop down in Customers[Customer Name]. I want to show Customer Name which is in order to Check-In date. all this mentioned columns are in Bookings table and formula is putting in Customers table.

ORDERBY(
Show Bookings[CustomerName],
[CheckInDate],
FALSE
)

--------

SELECT(
ORDERBY(
Bookings[Customer Name],
[Check-In],
FALSE
),
TRUE
)

--------

I have tried following formulas and nonof them worked. Im not a programmer or expert in coding. So I'm humbly looking for help and advice.

[AleksiAlkio · Accepted solution]

You can use the ORDERBY() only with the key column like..
ORDERBY(
Show Bookings[CustomerID],
[CheckInDate],
FALSE
)

[tharaka89]

This is showing CustomerID istead of Customer Name in the drop down. Could you please help. Thanks

[tharaka89]

Got it sorted. Thank you very much

[VarunChandran]

If you are going order the name based on date then use

Select

(Show Bookings[CustomerName],

IN(

[CheckInDate], Sort(Select(Show Bookings[CheckInDate],true),true)

)

)