How do I use predecessors to ensure a portion of rows are complete before being able to go to the ne
I am wanting to use this format for pre-con to ensure nothing is missed or overlooked. I want to mitigate mistakes from our project managers to prevent project issues by not allowing them to move to the next section until the section they are working on is complete. We also want to use conditional formatting to have the locked sections to be a color of our choosing until it unlocked. Is that feasible to implement?
Best Answer
-
@Nick Esparza Sounds like something like the Ready to Start template I developed. Would have to think about the sections aspect, but definitely can color code or unlock row by row based on predecessors being completed using this.
See here:
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Answers
-
@Nick Esparza Sounds like something like the Ready to Start template I developed. Would have to think about the sections aspect, but definitely can color code or unlock row by row based on predecessors being completed using this.
See here:
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@Darren Mullen thank you for the helpful information. I booked a discovery call with you. Talk soon.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.2K Get Help
- 452 Global Discussions
- 155 Industry Talk
- 505 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!