Unparseable Cross-sheet Formula
Hello!
I'm trying to create a Metrics sheet that will count the number of consumer contacts each month by brand so that I can eventually use them in a dashboard. Here's my cross sheet formula. It keeps coming back unparseable but I can't figure out why:
=COUNTIFS({Consumer Contacts Range 3}, MONTH:MONTH, "January", BRAND:BRAND, "Brand A")
I think it has something to do with the cross sheet reference because when I try this formula in the sheet summary, it works just fine (but I need to pull data from different sheets into a dashboard widget so summary won't work). I must be doing something wrong when referencing the sheet?
TIA
Answers
-
Hi @jprovateare,
The formula should look something like this.
=COUNTIFS({Month},="January",{Brand},="Brand A")
with a cross-reference to month and brand.
Hope this helps,
Dave
-
Aha! I understand now and I got it. Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!