- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 16, 2023 10:38 AM
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)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 16, 2023 12:00 PM - edited ‎Jun 16, 2023 12:06 PM
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!
