Whatever your industry or maturity level, Smartsheet helps you drive enterprise efficiency and agility. It’s a powerful solution built to grow in response and adapt to your needs by providing the key ingredients to success, including one that’s sometimes overlooked–flexibility.
Because Rego expert guides have boots-on-the-ground experience as Smartsheet implementers and administrators for every kind of company, we have first-hand knowledge about that flexibility. So, when a customer reaches out for a Smartsheet solution to the following scenario, it’s familiar and easily remedied:
Let’s say you’re a Program Manager who needs to demonstrate Project Health in an objective format instead of relying on subjective and non-standardized Green, Amber, and Red criteria from the project management team.
After meeting with Project Managers, you reach an organization-wide consensus on how to label projects:
- Green label: Projects that are projected to finish early or on time
- Amber/Yellow label: Projects that are expected to finish one to four days late
- Red label: Projects that will finish five or more days late
One of Smartsheet’s many fantastic features is that there are many ways to solve a problem. We built the following Smartsheet solution to give users multiple columns that could be used for other purposes, such as reports or dashboards. Our solution also eliminates massive formulas that can be difficult to debug, especially when items change, such as range or criterion.