Workflow or Conditional formatting for tasks

H.L.Dixon2021

Screenshot 2022-01-11 132846.png

Hi, we are trying to organize a task list to show tasks that need to be completed if they answer yes or no to a parent row.

Example screen shot attached...when row 2 is Yes we would like to show some tasks between 3-11 without a strikethrough, and if the answer is No then those items that were previously formatted with the strikethrough, now are not and the other items are.

Any other advise on how to show some items to be completed when a condition are met is appreciated if there are other ways to accomplish this.😖

Jeff Reisman

I'm thinking you could do this with some hidden helper columns and the PARENT function.

Create two new columns, one called ParentYesNo and the other called ConditionType.

In the ParentYesNo column, add the following:

=PARENT([Yes/No]@row)

This will record the value of the parent's Yes/No column in each child row.

In your ConditionType column, enter the following:

For the rows that should be strikethrough when it's "Yes", enter =[ParentYesNo]@row + "A"

For rows that should be strikethrough when it's "No,", enter =[ParentYesNo]@row + "B"

That sets your ConditionType column values to YesA, YesB, NoA, or NoB.

Set your conditional formatting rules:

When ConditionType = YesA, strikethrough the Task Name column.

When ConditionType = YesB, do not strikethrough the Task Name column.

When ConditionType = NoA, do not strikethrough the Task Name column.

When ConditionType = NoB, strikethrough the Task Name column.