Looking for a SmartStrategy to be a Smarter-Smartsheet-er (Basic Process Question)
I have been using Smartsheet for over 4 years. I have not used it with the efficiency it deserves. I am wondering if it is better to have several "smaller" sheets (i.e. "Contacts," "Customers", "Vendors") and then, by using a common "primary" column, utilize the the "Report" function to create...well, reports. OR, and this is what I've currently done: Create at massive Sheet that has a ton of this info and I've manipulated it with a great many filters and conditional formatting tools. I am not sure what is a smarter way to proceed. I am a company of 1. At this point, to those people I'd be sending things to, I: A) Don't have "buy in" from my community with filling out Smartsheet forms, or B) using Smartsheet's many options to collaborate and monitor projects, or C) Anyone able to break away from Google Sheets or Excel, or Word Tables. That said, I have no problem trying to get them on board with a certain degree of all of this, but, I don't need them to be actively checking a Dashboard, Commenting, Reviewing,--I will be the only true User. Again, this is basic and I've combed through many webinar/help topics/videos and have not been able to quantify it all. Any thoughts or direction would be much appreciated. This Community has saved my bacon a number of times, but I could probably avoid many problems if I start off on the right foot. I'm willing to do a re-design and re-entry of all my current sheets in order to make it work smoother. Thanks.