Orderby 2 columns first name and last name

[RickM]

I am trying to get a drop-down to sort by last name then first name.

i have 2 columns in my [Employee] table 

First                 Last

Fred               Flintstone 

Barney          Rubble

i would like the drop-down to display

Fred Flintstone

Barney Rubble

Do I need to combine the name in one field?

or can I order the list like it is?

I am brand new to AppSheet 2 days. No experience except trial and a lot of error.

TIA.

[Vincent_P]

Hello, 

I don't test it, but maybe make a computed colum where formula is [first name ] & " " & [last name] and then for your dropdown use orderby function 

ORDERBY(Employee[computed column], [last name], true, [first name], true)