I have a “Related meetings” virtual column in my table. I want to pull the latest meeting date from the column. Is that possible? I do not need any other info just the latest date.
Solved! Go to Solution.
Try INDEX(SORT([Related Meetings][Meeting Date]), 1)
subbing in your column’s names.
Is your “related meetings” column of type list and referring to a second table with a calc like REF_ROWS() or similar? Or, is it something else, i.e. what is the data type for this column?
Yes is it is a ref row and it’s a date time data type.
Try INDEX(SORT([Related Meetings][Meeting Date]), 1)
subbing in your column’s names.
IT WORKED! Many thank yous Happy New Year
One question, the date time shows the seconds. Is there a way to remove them easily.
You can find an option under the column’s definition. It’s called “Ignore seconds”.
User | Count |
---|---|
43 | |
29 | |
24 | |
21 | |
13 |