Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

Topic Labels: Formulas
454 1
Showing results for 
Search instead for 
Did you mean: 

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.