
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 08, 2021 09:22 PM
Imagine I have 2 tables: STORE and ITEMS
STORES are linked to the items table so that multiple items can show up in each store.
The ITEMS table has a column called “Last Updated”, which is a bunch of dates
I created a lookup field on the STORE tab that looks up the linked ITEMS “Last Updated” field.
This returns a list of dates in a string: 10/20/20, 10/19/20, 11/2/20, etc
Question: I want to take the Max of this field but I don’t know how to do this. I tried a formula like: Max({Items Last Updated}) but that doesn’t seem to work. Sadly, Airtable doesn’t seem to have a Split() formula equivalent.
Any ideas? Thanks in advance!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 08, 2021 11:02 PM
Create a rollup field instead of a lookup field, and use MAX(VALUES)
as your formula.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 08, 2021 11:02 PM
Create a rollup field instead of a lookup field, and use MAX(VALUES)
as your formula.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 08, 2021 11:17 PM
Worked like a charm, thank you!
