Skip to main content

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

  • August 14, 2020
  • 1 reply
  • 11 views
C

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

Nathalie_Collin
Forum|alt.badge.img+18

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.

Terms & ConditionsAccessibility statement