Auto Calculate based on task being complete ahead of schedule
I am somewhat new to SS 1st and foremost.
In the example row 88 is completed ahead of schedule. (Task=complete and % Complete=100%) Row 90 task is driven from the completion of task 79 “Manual Set-up Station”.
What is the right way to set this up so that if we are ahead of schedule and we have resources I want the start of row 90 to be 10/22 based on 100% complete on row 79?
Our goal is to have the manufacturing team update SS and not make the process difficult for them. Updating the % Complete is more than doable for them. Having them update dates is not something we want them to do.
Answers
-
What exactly is the problem, and what exactly are you wanting to accomplish?
-
I am somewhat new to SS 1st and foremost.
In the example row 88 is completed ahead of schedule. (Task=complete and % Complete=100%) Row 90 task is driven from the completion of task 79 “Manual Set-up Station”.
What is the right way to set this up so that if we are ahead of schedule and we have resources I want the start of row 90 to be 10/22 based on 100% complete on row 79?
Our goal is to have the manufacturing team update SS and not make the process difficult for them. Updating the % Complete is more than doable for them. Having them update dates is not something we want them to do
-
Hi @Rob M W,
If I'm understanding right....
"What is the right way to set this up so that if we are ahead of schedule and we have resources I want the start of row 90 to be 10/22 based on 100% complete on row 79?"
For this you will want to use the Predecessor column. In the Predecessor column for row 90, enter 79. Then once the end date for 79 is entered, the start date for 90 will be updated to the next working day after the completion of row 79.
"Our goal is to have the manufacturing team update SS and not make the process difficult for them. Updating the % Complete is more than doable for them. Having them update dates is not something we want them to do."
If you want a team to use Smartsheet, and need to ensure they don't touch any specific column; there are a couple different options. 1.) Dynamic View, if you have this in your plan. 2.) Use a Report, and only include the columns you want that team to see/update. Then share the report with them, and ask them to make their updates there (Edit access to the underlying sheet is still required).
Hope this helps!
All the best,
-Ray
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!