cross-sheet formulas from each sheet to collect the metrics?

Charli Charli

I have 5 sheets with project data. I have developed Master Metrics Sheet where I want current numbers of all the 5 sheets collated and always updated. BUT, I dont know how to drag and fill auto sum formula to apply across the sheets. HOW CAN I USE a cross-sheet formulas from each sheet to collect the metrics?

Andrée Starå

Hi @Charli Charli

Not sure I follow!

If you want to add metrics from each sheet, you'll need to manually add the cross-sheet references for each sheet. Unfortunately, there isn't a way to create them automatically.

Make sense?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!