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

[Giora_Giora]

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.

[ScottWorld]

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 · Accepted solution]

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), 
  '[^,]*$'
)

 Link to base