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, Author of: Smartsheet Architecture Solutions
Get my 7 Smartsheet tips here
Take your Smartsheet knowledge to the next level and become an expert. Join the Smartsheet Guru Elite
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, Author of: Smartsheet Architecture Solutions
Get my 7 Smartsheet tips here
Take your Smartsheet knowledge to the next level and become an expert. Join the Smartsheet Guru Elite
-
@Darren Mullen thank you for the helpful information. I booked a discovery call with you. Talk soon.
Help Article Resources
Categories
Check out the Formula Handbook template!