Help to create a "3 Dimensional Reference" Formula
I am trying to create a sum of the same cell in four different Metrics Sheets. I have created the following formula and I get the Unparseable error. Would appreciate help, please.
Answers
-
For some reason the formula did not show up in original request. Here is formula
-
You seem to have double accolade everywhere, I've never seen that, is that normal? {{ }} I usually only have one to open and one to close my references { }
-
If I take the second set away, it gives me a Circular reference error.
-
Hi @Carole M. - Perhaps this will provide a baseline for you. Hope it helps! 🙂
=SUM({01_Metrics Sheet_Complaints-QTR1_2025 Range 1}, {01_Metrics Sheet_Complaints-QTR2_2025 Range 1}, {01_Metrics Sheet_Complaints-QTR3_2025 Range 1}, {01_Metrics Sheet_Complaints-QTR4_2025 Range 1})
Best Regards,
Yvonne Smythe
-
Thanks all. I found a different way to do the same thing.
-
Hi @Carole M.,
Glad to hear you were able to figure this out! Could you share the solution you found to help others reviewing this thread?
Thanks,Georgie
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 40 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!