How to get a list of dates searched by criteria at the related table and then get the earliest.

[Alex_Ye]

There is a file

Sheets file link

There are two pages . At the page Lecture blocks at the column B - First lesson date, I need to have an earliest date from the related list of data from the page “Lessons”. 

Is it possible to do some how at my app-sheet?

[TeeSee1 · Accepted solution]

try

MIN( //edited
 SELECT(
  Lessons[Date],
  [id_block] = [_THISROW].[id_block]
 )
)

[Alex_Ye]

Thank you so much, it works.🎉