- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 21, 2025 08:05 AM
I am trying to create a formula that will take the latest date from a linked field (Appointments) and enter the latest date in a new field called "Last Appointment." I tried to generate a formula using the AI which gave me this formula:
DATESTR(ARRAYSLICE({Appointments}, -1, 1))
but it keeps coming back with an ERROR.
Any help would be appreciated.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 21, 2025 10:38 AM
To do this, you would need to create a Rollup Field that points to your linked record field, and then you would choose the appointment date from the field drop-down.
Then, for your Rollup Field's formula, you would use this formula:
MAX(values)
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
