REF - DROP DOWN - ASCENDING ORDER

AppSheet AppSheet Q&A
1

hi,

I have a valid if expression for checking a condition in REF Type column :

IF(ISNOTBLANK([EMP ID]) ,[EMAIL] = [EMP ID].[EMAIL ID], FALSE)

Now , I need a dropdown in ascending order . How to use orderby(), sort () functions here ?

2

You will want to use a SELECT function:

ORDERBY(
        SELECT(*this table*[EMP ID], [EMAIL] = [EMP ID].[MAIL ID]), 
        [column to sort by]
)

Update the blue text.

NOTE: You do not need to test of [EMP ID] is populated. If it is blank, then no match and no row returned.

I hope this helps!

3 Likes
3

[EMP ID] is not a required column *

Expression which you have given does it throw error ? Because I need an error message. So that user can understand he has entered wrong inputs .

If at first [EMP ID] is entered and [ EMAIL] is entered at second. Values to be checked based on the condition. If the condition fails , it should notify the user.

4

Why do you need sorting values?

You just have 1 valid value, not a list of valid values. Just use this simple expression, everything else is a waste

[EMP ID].[EMAIL ID]

1 Like