Help

show the minimum date from dates in other columns

Topic Labels: Dates & Timezones Formulas
519 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!