Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Enter last appointment date forumula

104 0
cancel
Showing results for 
Search instead for 
Did you mean: 
gospelsoulcare
4 - Data Explorer
4 - Data Explorer

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.

1 Reply 1
ScottWorld
18 - Pluto
18 - Pluto

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