Help with Ancestors forumla to show Parent Row information

Hello Smartsheet Community

Stuck with using Ancestors based formula to do the following:

  1. In the process of building a sheet to roll up task and eventutally project information so that as we decompose/create more children from the parent row, the parent task from the parent row shows up under the parent task column. So in this example, task #2 and task #3 will always have a reference back to Task #1 as the parent.
  2. The screen shots below show the INDEX(ANCESTORS...) formulas I've been using which based on what I've found so far in the SS community, should work (?). What are am I missing?

Thanks for any help, this community is AWESOME!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!