Best way to show KPI's across multiple projects and teams?

edited 09/20/22 in Smartsheet Basics

Hello all,

I'm trying to determine the best way to capture multiple KPIs on a dashboard.

Each cross-functional team has their own sheet where they manage projects. What is the best way to have them capture data metrics (the KPI's might be different per team- hours saved, increased NPS, $ Saved) that roll up to a dashboard?

Please let me know if you have any thoughts.