Removing parents from formula.

Options
WG
WG ✭
in Formulas and Functions

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")

Thanks!

WG

· Share on FacebookShare on Twitter

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    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:

    image.png 


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

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ 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"

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!