Sheet setup for scalable data

CWibben ✭✭✭
edited 03/06/24 in Smartsheet Basics

Looking for a best practice to set up a scalable (target vs. actual, month-over-month) sheet - There are 15 specific varying metrics (e.g. numbers, $, %) collected monthly by different people. Each metric will require both actuals for the prior month and a target for the next month. I would like to show both monthly metrics and trends over time. Any suggestions on the best way to set up the sheet(s) so that I can easily create reports & show in a dashboard?