"If clause" in Dependancies
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
-
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 EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 287 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!