Metric sheet with multiple cross references

I created a metric sheet to use for a dashboard and I want different cells to cross reference different smartsheets. My issue is when I change the cross reference for one cell, it updates the cross reference for every cell in the metric sheet. Is there a way around this?

Best Answer