Dynamic Production Date Schedule
I work for a small company who manufactures kitchens in Oxfordshire. We are able to make 9 kitchen units per day, 4 days a week - so a kitchen that has a total of 27 units would take 3 days to complete.
As there are many external factors that can delay or bring forward the manufacturing dates, there are many occasions where the schedule needs to be adjusted to suit this - we currently write our schedule of dates/ production schedule on a whiteboard in the workshop so when it has to be changed it can be very time consuming.
I am wondering if there is a way to utilise smartsheets to make this more efficient. For example, I am ideally wanting to change a specific customers finish date and the rest of the customers dates automatically update, chronologically, to suit. Ideally, changing all dates to ensure there are no overlapping projects.
The columns could be something like: Customer Name, Kitchen Size, Estimated Time, Start Date, Finish Date
If any more information is needed please let me know, any help would be greatly appreciated :)
The Kitchen Man
Answers
-
I hope you're well and safe!
Yes, you could use the Dependencies feature, so when something changes, everything follows.
Make sense?
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives