formula works fine in individual cells but can't be converted into a column formula



I'm calculating the attendance with this formula (where {date} is a reference to a different sheet that should match a date in a cell), and it calculates correctly in individual cells, but when i'm trying to convert it into a column formula, i get a message that the syntax is not quiet right.

What is a problem here if it works in the individual cells? The all "0" is because nobody yet checked in for the event, but the numbers in the sheet for the previous events are correct.

The column type is Text/Number.

=COUNTIFS({date}, [Event Date]$1, {demographic}, [Demographic Groups]@row)

thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!