"If clause" in Dependancies

Jose da Silva

Hi all,

I am struggling to find a solution for this.

I have 15 individual sheets for a project.

One of the activities on sheet 2 will include a "yes/no" question.

If yes, then sheet 3 needs to be completed.

If no, then sheet 3 will not be necessary.

I can't see an efficient solution for this. Any suggestions?

 

Thanks!

Andrée Starå

Hi Jose,

Depending on the structure of your sheets my recommendation would be to use cross-sheet formulas so that when the activity on sheet 2 is yes or no it will mark sheet 3 as complete.

Would that work for you?

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

Paul Newcome

You could also use a helper column next to the yes/no column and enter the following:

 

=IF([Yes/No Column Name]@row = "Yes", "Please complete sheet 3", "")

 

Basically if they answer yes then "Please complete sheet 3" will pop up in the cell next to their answer. You could then use conditional formatting to make it kind of pop out at them.

If sheet 2 is being revisited by them, or if their progress is being tracked you could add another column as a checkbox type on sheets 2 AND 3. 

Have the checkbox column on sheet 3 denote whether the sheet is complete or not. Then enter an IF(INDEX(MATCH statement in the checkbox column on sheet 2 that will find their row in sheet 3 and check the box on sheet 2 if the box on sheet 3 is checked as complete.

 

You can also use conditional formatting to "hide" the next step on sheet two until sheet 3 is complete. Basically you would say that if the sheet complete box is unchecked then apply the format of white fill and white font to the remaining columns. Once they complete sheet three, the box on sheet 2 will check itself and reveal the cells relating to the next step.