How to conditional format the parent task based on child task


Hello All,

I am new to smartsheet and I am trying to highlight the parent row based on child rows. here is the use case, I have 2 levels of Indentation to my sheet, and I have conditional formatting applied which turns a row red if my condition is met (Condition is if my end date is in past and % complete is not 100% turn that entire row into red). I want to turn the parent row into red if any of the child row is red. I am not sure how to achieve this. I read multiple threads but was not able to figure out. can someone please help


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

    Hi @Mayur Mehta

    I hope you're well and safe!

    You'd add a so-called helper column with a formula that checks the condition and then reference that in a conditional formatting rule.

    Make sense?

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic weekend!


    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 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.

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Mayur Mehta 

    Hope you are fine, please add a helper column call it "Highlight" for example and use the following formula in this column and convert it to column format formula:

    Highlight=IFERROR(IF(AND(Status@row <> "Complete", End@row < TODAY()), 1), "")

    then use the following conditional formatting:

    the formula will give 1 for condition in Highlight column

    PMP Certified

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