Add children rows automatically with same format

bradfurt13

I have a parent row where its high level description of task, The clhildrens rows are action items and next steps that have unique formatting. I would like collaborators with minimal SS experience to easily be able to add children row with same formatting. Right no, the only solution is to copy/past which isn't ideal.

 

Thansk!

bradfurt13

I apologize for terrible spelling above!

Andrée Starå

Hi Brad,

I have a solution where you would set up a Level formula and then use that in the conditional formatting. I'll get back to you later today and explain it.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andrée Starå

Hi Brad,

Try this.

You can use the below formula with conditional formatting if you choose not to include any levels. Add the formula to a column named Level or similar.

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

The same version but with the below changes for your and others convenience.  

=IF(COUNT(CHILDREN([Task Name]@row)) > 0. COUNT(ANCESTORS()) + 1)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Would that work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting