Pre-select 10 values from a list box

[Anonymous]

Hello,

I'm wondering if it's possible to automatically select the top 10 values from a list.

With top 10 I do not mean a ranking, I mean the first 10 entries that show up based on the sort order.

This pre-selection should happen when entering the sheet (on activate sheet trigger).

Any help welcome.

[Anonymous]

The solution below works, with a restriction - sort order is load order.  So, if you use it, you have to load the field in the script in a specific order.

Action - select in field.

Field - FieldName

Search string - ='(' & concat(distinct if(FieldIndex('FieldName',FieldName)<=10, FieldName), '|') & ')'

If it is not exactly what you want, maybe it at least gives you an idea,

[Anonymous]

Hi,

it is the same that say Michael Solomovich so thank him! 🙂

I was slower but I attach the sample file.

You can try also with a macro (you can find many post in the community) but I dont know if it is a good approach.

Good luck.

Regards.