Metric Sheet

EmilyD ✭✭✭
edited 03/08/23 in Formulas and Functions


I built a master task list in Smartsheet with metrics. The intention would be that the master is a template that others could replicate and the data they have on their sheet would update the metric sheet. Is that possible?

Thank you,



  • Colleen Patterson
    Colleen Patterson ✭✭✭✭✭✭

    @EmilyD to confirm: are you looking for there to be a single metric sheet for all replicable task lists, or for metrics to be assigned to their own task list?

    The goal would be during the replication process that you would have both sheets in a folder, and in the duplicating the folder workflow, you would have reports, dashboards, sheet hyperlinks and cell links refer to Newly created sheets.

    If you want it to point to the source sheet, in duplicating the task list, you would have that setting point to original sheets.

    If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!