Report showing parent task?


Hello, I would like to get a report showing the parent tasks. Is it possible? Thank you


  • Annie R.

    Hi Jlind,

    Here's how I go about it:

    Create a column for Parent Rows using the column formula: =JOIN(ANCESTORS(Task@row), ": ")

    This returns a string of the text of the parent rows concatenated together with the delimiter ":" (which is optional, use the delimiter of your choice, e.g., comma, semi-colon).

    When you create your report, include the Parent Rows column to display the parent rows with each task.

    In some cases, I like to take it a step further to include in my reports only the tasks at the lowest level (i.e., only those that do not have sub-tasks). I do this by creating a column for Count of Child Rows using the column formula: =COUNT(CHILDREN(Task@row))

    This returns a value of 0 for those tasks with no sub-tasks. Use this as a filter criterion for the report.

    ~ Annie ~

  • Jlind
    Jlind ✭✭
  • joemontana

    This is great- thanks!!!

  • Jeff Cumbie

    When I use the formula above to achieve this, I get the result in the cell #UNPARSEABLE. Any solution to this?

  • Genevieve P.

    Hi @Jeff Cumbie

    You'll need to replace the "Task@row" portion with whatever your column name is... for example:

    =COUNT(CHILDREN([Primary Column]@row))


    =COUNT(CHILDREN([Task Name]@row))

    I hope that helps!


    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

  • Jeff Cumbie

    Thank you. That fixed the issue and the formula s working for me now. Much appreciated!

  • ✭✭✭

    Is it possible for you to select how many layers of parents are displayed? For example, I have a parent row for my whole sheet that tells the project name but I don't need that included in the description for child tasks 3 deep. Is there an adjustment I can make to the formula?

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭


    I hope you're well and safe!

    Not sure I follow! Can you elaborate?

    Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

    I hope that helps!

    Be safe, and have a fantastic week!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.