Hi! Is there a way for me to pull only the parent details in my report without having the subtasks?

Options

Hello!

I am trying to create a report and pull only the parent task details- is there a way to do that? could you help me with a formula?

Answers

  • KPH
    KPH ✭✭✭✭✭✭
    Options

    You could add a helper column (that you can hide and ignore) with a column formula that counts the number of children

    =COUNT(CHILDREN())

    Then in your report filter on only those where the count of children is greater than 0.

  • Rikap
    Rikap ✭✭
    Options

    Thank you - is there a way I can pull this to another report with the same formula linking the sheets?

  • KPH
    KPH ✭✭✭✭✭✭
    Options

    I'm not sure I understand the question. The formula needs to go into the sheet (or sheets). You can use the result of the formula to filter your report.

    In the report click on filter and set it up like this, where "New Column" is the column that contains the formula =COUNT(CHILDREN()).

    This will include only the parent rows in the report.

  • Rikap
    Rikap ✭✭
    Options

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!