Best way to speed up Smartsheets
Hi, our current tracking tools are too complicated for Smartsheets and things are slowing down. I'm not sure the best place to start to speed things up. We have about seven inter-related pages, including: one main master page that we source our static variables from, a few reports (these are sheets where I paste in data from other databases) that we source non-static information, a very complex sheet we use for our main working dashboard (although it is not a "Dashboard", it's just a sheet), and a few ancillary pages that we use as tools. Frankly Smartsheets is not the appropriate tool to track all this, but this process is going away in a year and I need to keep things going until then. Can someone give me a bullet list detailing how to best go about troubleshooting to optimize a Smartsheets ecosystem?
I have implemented a lot of complicated, likely resource-heavy formulas to implement our business logic, and we have a LOT of conditional formatting. I have a co-admin and I saw that they had recently added PAGES of new conditional formatting logic.
My co-admin and I have different philosophies regarding report usage as well. I am pro-reports because it keeps people off our main page and simplifies things for them (our main page has about 100 columns--most hidden, but it's still very big). I think the co-admin believes that reports slow things down. Ideas?
@Paul Newcome? You seem to be the resident guru here :)
Help Article Resources
Check out the Formula Handbook template!