Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Looking to display the last order date of a customer

Topic Labels: Formulas
394 4
Showing results for 
Search instead for 
Did you mean: 

My first table is a list of orders with a date and a customer name that is linked to the customer table I need to display the date of the last order on the customer table.

4 Replies 4

Use a Rollup field with a MAX(values) aggregation.

@Kamille_Parks how do I do that?

Go to your Customers table, make a Rollup field, select the orders Table, select the Order Date field, enter MAX(values) as the aggregation.

@Kamille_Parks it returns 0 for all cells