Combine Cross-Referenced Sheets

ker9
ker9 ✭✭✭✭✭✭

Hi - I have 6 Summary sheets that are cross referenced to 6 Regional sheets. These have formulas gathering totals by person. Sort of mimics a pivot table. Works great for stacked bar charts.

I'd like to combine all the totals for each person in one sheet. People might appear on more than one Summary sheet. The names may change (add/delete). The Summary sheets are using a formula to get the distinct names from the Regional sheet.

Unfortunately, a report brings in duplicate names and I'm looking for one row per person with totals from all Summary sheets.

Looking for suggestions on best method to get all the names, no duplicates, and keep them updated.

TIA!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!