I have a Requests table which includes Date a...

[Onder_Uluyol]

I have a Requests table which includes Date and Speaker_ID among other columns. The following gives me the requests by a speaker, but the list is not sorted.

=REF_ROWS(“Request”, “Speaker_ID”)

How can I sort this list by Date or show the last 10 requests for example?

[Aleksi_Alkio]

Modify the system generated inline view for that table. Because it’s a table view, you can sort it with the date field for example.

[Onder_Uluyol]

I am sorry, by “table” I meant the source spreadsheet.

[Aleksi_Alkio]

I’m afraid you can’t sort the source spreadsheet itself. You can sort the view.

[Onder_Uluyol]

I am not trying to sort the source spreadsheet. =REF_ROWS(“Request”, “Speaker_ID”) gives me a list of requests for a particular speaker. I need to sort this resulting list by date. Date is a column in Request sheet and not in Speaker sheet.