Testing kits were going to go out to labs all over the country and Roche needed to track them through their life cycle. That required an easy-to-use entry tool since the personnel in testing Employees Coronavirus labs wouldn’t be able to use a complex interface. After the data was collected, it needed to Prepardeness Portal be immediately accessible to Roche to inform the allocation of supplies. This required the automation of reporting and complex logistical hierarchies. For three days, our team worked around the clock, and by Tuesday, March 17, they had a working Travel/Illness Travel/Illness Con昀椀dential - O昀케ce prototype that was immediately rolled out to testing labs around the country. By the following Intake Form Intake Sheet At Risk Employees Locations Monday—nine days after Mark received the call from Roche—the team achieved its 昀椀rst day of 100 percent data accuracy, setting the stage for the largest and fastest disease testing deployment in human history. But we weren’t done. With pockets of virus spread appearing suddenly nationwide, public HR Team/ COVID-19 agencies were struggling to keep their communities safe. Those policymakers needed data, Responsible Persons Comms Tracker Coronavirus and they needed it fast. prepardness What began as a project to guide and track the allocation of testing kits became a Herculean setup dashboard e昀昀ort to collect the epidemiological data policymakers needed to guide public health decisions. Risk Assesement To meet that need, the team designed tools to capture test results and other metrics and Matrix created easy-to-use dashboards to render the data meaningfully to a wide variety of end users. By late April, the Roche-Smartsheet team was receiving and quality checking data during the day, then seeing the data referred to in a White House press brie昀椀ng that evening. For those in the room at Smartsheet, it was surreal to see the numbers they’d put together broadcast “It’s the most meaningful live just hours later on the national news. And it drove home just how much the work they were work I’ve ever done.” doing mattered. The data Roche gathered through its testing deployment gave medical professionals, leaders, and the public their 昀椀rst way to understand and begin to manage the COVID-19 pandemic. MINDY CORDOVA When vaccines became available in late 2020, the solution Roche and Smartsheet had Customer Success Manager, Smartsheet developed to deploy testing kits was repurposed to support the vaccine rollout. | 27 SMARTSHEET IN ACTION