"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!

Find more posts tagged with

Sheets

Formulas

Project Management

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…