Formula to auto-transfer data into another sheet
The company I work for uses Smartsheets to build schedules. We have both weekly and daily schedules. However, I've noticed a lot of our time is spent daily going through and transferring information from the weekly to the daily grids.
I didn't know if there was a way for me to auto-link certain grids to a grid on another sheet so that, for example, when I enter data for manager on the Monday slot for the weekly grid, it will automatically put that data in the manager slot on Monday's separate daily grid.
It appears this may be able to be done via conditional formatting, but the exact way I would do so eludes me. Any help is appreciated.