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

(Onder Uluyol) #1

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) #2

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) #3

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

(Aleksi Alkio) #4

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

(Onder Uluyol) #5

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.