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

Topic Labels: Formulas
912 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1

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)]

Annotation 2020-08-14 095356

Here’s a sample base to showcase.