Rollup a field of the earliest due date and show up the Title of that data

[ca_abcdefg]

I got two table in a base, one is main table which show big categories
The other table is record the small task of the big categories (each small task data have link to the big categories)

Can the main table rollup the earliest due date of the small task of that big categories and show up the due date and title of that small task in a same block?

[Nathalie_Collin]

Hi @ca_abcdefg :wave: . Welcome to Airtable Community :smiling_face_with_three_hearts:

Yes this can be done by adding a Rollup column and aggregating hte formula [min(values)]

Here’s a sample base to showcase.

Airtable

Airtable: Organize anything you can imagine

Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.