How to conditional format the parent task based on child task

Mayur Mehta

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å

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!

Best,

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!

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