Working on formula to return the value of the NEXT CHILD row in PARENT column
I have a column called Project with a PARENT row called PROJECT 1. I am looking for a formula to use in another column (WHATS NEXT) that will return the value of the next CHILD row, until there are not more CHILDREN.
Appreciate any insight on this. Seems like it would be simple but I don't want to COUNT the values I want to return the CONTENT of the next row of the CHILDREN.
Help Article Resources
Check out the Formula Handbook template!