List of suggested values to list specified number of highest values in list

AppSheet AppSheet Q&A
1

Hi everyone,

I am looking for help with a suggested values list expression/formula, to list only the 30 highest numbers of a [Batch Number] column.

Also taking things one step further is it possible to create an expression to list only the 30 most recently used numbers of the [Batch Number] column.

I am currently using the expression, Tablename[Batch Number] although I for-see it being a very large list in time so just trying to clean up the suggested list by reducing the options.

Any help would be greatly appreciated.

Kind regards,

Jonesy

2

To list only the 30 highest numbers of a [Batch Number] column, you can use the following expression in the Suggested Values property of the column:

TOP(
SORT(
SELECT(Table Name[Batch Number], TRUE),
TRUE
),
30
)

To list only the 30 most recently used numbers of the [Batch Number] column, you can use the following expression in the Suggested Values property of the column:

TOP(
SORT(
SELECT(Table Name[Batch Number], TRUE),
TRUE
),
30
)

Assuming you have a separate [Usage Date] column that tracks the date and time when each [Batch Number] value was used, you can use the following expression to list the 30 most recently used values:

TOP(
SORT(
SELECT(Table Name[Batch Number], TRUE),
[Usage Date],
TRUE
),
30
)

1 Like
3

Absolutely super @Uk !!! Thank you very much!!!

2 Likes