Sign in to submit new ideas and vote
Get Started

new GRANDPARENT() function

Nik Fuentes
Nik Fuentes ✭✭✭✭✭

I would greatly appreciate a Grandparent function, especially since PARENT(PARENT()) throws an error. I know we have ANCESTORS(), but that gives you the number of ancestors and I need the specific ancestor value.

Ideally, the GRANDPARENT() function would be GRANDPARENT( [reference], [# of generations back] ), that way it could also serve as a GreatGrandparent [etc] function.

With this would hopefully come a GRANDCHILDREN() function that works identically but in the other direction.

10 votes

Idea Submitted · Last Updated