Super efficient and organized

Smartsheet was used by my organization's marketing and creative departments to track all of our information. We have Smartsheet docs for contact sheets, for scheduling, and for tracking. One of the things we used Smartsheet for was to track which film studios had purchased ad buys with our owners because we needed that information to know what materials we need to create. Every week, we would generate a report on this spreadsheet, which would sort the data and give us only the relevant information for our weekly meetings. We would search by which of our owners needed the content, and then by date, so that the correct liaisons could look at their sections and then know what to work on based on the date. We also linked many of our smartsheets to a large dashboard, which was created each month, that allowed each of us to input specific information into our own personal Smartsheet docs and all of this info, combined with everyone else's, would populate into the larger dashboard, which could be looked at as a whole. That way, we each only had to put in our information once, and it would update the master dash for everyone.