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.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.