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

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @TheKitchenMan

    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: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.