Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Max of a bunch of status update fields

Topic Labels: Formulas
Solved
Jump to Solution
1328 2
cancel
Showing results for 
Search instead for 
Did you mean: 
TWu
6 - Interface Innovator
6 - Interface Innovator

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!

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Create a rollup field instead of a lookup field, and use MAX(VALUES) as your formula.

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

Create a rollup field instead of a lookup field, and use MAX(VALUES) as your formula.

TWu
6 - Interface Innovator
6 - Interface Innovator

Worked like a charm, thank you!