Help

Re: Add a Formula Field to See the Newest Item Added to a Rollup Field

Solved
Jump to Solution
765 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Giora_Giora
5 - Automation Enthusiast
5 - Automation Enthusiast

My table has a Rollup field (let's call it 'Titles Field').

I used the ARRAYJOIN(values, ', '), so the titles are separated by commas.

However, I want to add a Formula Field that show only the Newest/Latest title added to the rollup field.

Please advise.

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

I believe the array displays in order from earliest linked to most recently linked, and so you could perhaps try using this in your rollup:

REGEX_EXTRACT(
  ARRAYJOIN(values), 
  '[^,]*$'
)

Screenshot 2023-06-05 at 6.37.39 PM.png

 Link to base

See Solution in Thread

2 Replies 2

Unfortunately, Airtable doesn’t offer that function natively, even though customers have been requesting it for years & years. Be sure to report this as a feature request to support@airtable.com.

In the meantime, you will need to use the trick I outline in this episode of the BuiltOnAir podcast: https://youtu.be/T9RWQndgKoQ 

If you have more questions, I may not see your followup questions here but you can find me & other Airtable experts here.

TheTimeSavingCo
18 - Pluto
18 - Pluto

I believe the array displays in order from earliest linked to most recently linked, and so you could perhaps try using this in your rollup:

REGEX_EXTRACT(
  ARRAYJOIN(values), 
  '[^,]*$'
)

Screenshot 2023-06-05 at 6.37.39 PM.png

 Link to base