Unparseable Cross-sheet Formula

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!