"If clause" in Dependancies

Jose da SilvaJose da Silva ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions
06/29/18 Edited 12/09/19

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!

Comments

  • Andrée Starå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

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Paul NewcomePaul 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 or Register to comment.