Master build schedule to sync with other sheets?
I am not having any luck searching for a solution to this. My company has a production schedule in Excel. It changes daily. Builds get added, removed and moved around on a regular basis. We have two different engineering departments that are managing their work load in Smartsheet. The two departments have very different requirements and needs from Smartsheet. However, they are both are taking the same build schedule from the Excel master and putting that info into the two different engineering Smartsheets. It takes a lot of time to update both engineering Smartsheets when a change to the excel master happens. I am trying to find a way to have the Excel master drive the core info on both engineering sheets or have a master Smartsheet build schedule drive the two separate engineering sheets. As of now I can only come up with combining both sheets and have both departments work off one sheet. I would prefer not to go that route if possible. Any ideas out there?