Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
New Hierarchy Function - ANCESTORS()
I got super excieted when I saw the new Hierarchy functions, ANCESTORS() & PARENT().
I get PARENT(), know where I plan to use it and am happy to have it.
After testing out ANCESTORS() and reading the blog, I realize that it's primary intention is for forconditional formatting. ANCESTORS() Example Sheet
I'm curious to know if anyone has other use cases for ANCESTORS.