Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Mark parent row at risk if any child row is at risk?

Options
Jamison
Jamison ✭✭✭✭✭
edited 12/09/19 in Archived 2016 Posts

This would seem to be a "project settings" sort of thing, but i can't find it. Is there a formula that can accomplish this?

Comments

  • KrisWalsh
    KrisWalsh ✭✭✭✭✭
    Options

    Using the Status Column. Parent Row

    =IF(COUNTIF(CHILDREN(), "At Risk") > 0, "At Risk", "XXXX")

     

    You could also make the Parent a % Complete unless a child is 'At Risk'.

    =IF(COUNTIF(CHILDREN(), "At Risk") > 0, "At Risk", (COUNTIF(CHILDREN(), "Completed") / COUNT(CHILDREN())))

     

    Using a Flag Column

    Child Row Formula: =IF(Status4 = "At Risk", 1, 0)

    Parent Row Formula: =IF(COUNTIF(CHILDREN(), 1) > 0, 1, 0)

     

    RYG Layered Formula: If this row has child rows, then default to green unless it has a red or yellow child row. If it does, it will become red or yellow (red with higher priority).

     

     If it doesn't have children, turn green if Done checkbox is checked or if this task hasn't been touched yet. Turn yellow when the end date approaches in the next 7 days. Turn red if we're past the end date and complete isnt checked."

     

    -=IF(COUNT(CHILDREN([Task Name]8)) > 0, IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", "Green")), IF(Done?8 = 1, "Green", IF(ISDATE([End Date]8), IF([End Date]8 < TODAY(), "Red", IF(NETWORKDAYS(TODAY(), [End Date]8) <= 7, "Yellow", "Green")), "")))

  • Jamison
    Jamison ✭✭✭✭✭
    Options

    Oh my - I'll give a pre-emptive thank you. It may take some time to get through this.

This discussion has been closed.