Removing parents from formula.

Can anyone please assist with structuring this formula so the report does not include parent rows?

=IF(AND(Due@row < TODAY(), State@row <> "Complete"), "Red", "Green")




  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @WG

    Hope you are fine, you can solve that by adding a helper column in the source sheet to define the parent level and filter your report by using level 0 as a filter, the following is the formula that define the parent level:

    =IF(COUNT(CHILDREN(Task@row)) > 0, COUNT(ANCESTORS()) + 1)

    PMP Certified

    [email protected]

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!