Retrieving Ancestor (date) value from multi-level parent-child rows
I used the following formula to retrieve ancestor (first parent) date value of the multi-level parent-child rows for each row.
=LEFT(INDEX(JOIN(ANCESTORS(Date@row), ","), 1), 8)
The issue that I'm facing is the return value being "TEXT" despite having "DATE" column type. Since I have to use this return value in comparing other dates, suggest any other alternative to retrieve the value in DATE format
Help Article Resources
Check out the Formula Handbook template!