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

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?

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.

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.