Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

show the minimum date from dates in other columns

Topic Labels: Dates & Timezones Formulas
1056 1
cancel
Showing results for 
Search instead for 
Did you mean: 
JoLouLacey
4 - Data Explorer
4 - Data Explorer

I have a table that has numerous columns of date fields that tells me when a person first attended a specific workshop. (this is a linked field and reads from the individual workshop tables)

I want to be able to have a column that shows the earliest date of all the dates that this person(record) attended - essentially to give me the date they started engaging in workshops with us.

Does anyone how if this is possible and if so what formula to use

(I tried a MIN formula but it just gave me numbers rather than the date and I couldn't see an option to format it as a date)

1 Reply 1
Juliana
Airtable Employee
Airtable Employee

Hi Jo! Instead of a true formula field here, to produce the oldest date, you'll likely want to utilize a rollup field in the opposite table with the following formula (in conjunction with the linked record field) --

MIN(values)

After creating the rollup field, you can set conditions for the records you wish to roll up, such as described here.

 

Give the above resources a look over and let me know if you come across any questions while implementing this—happy to help!