Retrieving Ancestor (date) value from multi-level parent-child rows

Hi All,

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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!