Use trigger to select first possible value?

[bullish35]

I would like to set the value of a particular field when I navigate to a tab. For example, if I navigate to tab A and the field Market has no values selected, I would like to select whichever possible value is first in the list of values. Can I do that with a Select in Field or Select Possible trigger? Using what expression?

Thank you!

Ellen

[#2]

Sure you can

In Sheet Properties click Triggers and Add Action (Select in Field)

put into Field box your Field name such as:

F1

then write into Search Expression box:

=MaxString({1} F1)

or

=MinString({1} F1)

if the field ordered it will select minumum or maximum value available in your field

see attached example.

[Alejandro_Hernández]

try with =FirstSortedValue(field,field)