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

OshaK

Hello,

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!

Carson Penticuff

Unfortunately, Smartsheet does not allow reference a specific row ([Event Date]$1) in a column formula.

As a workaround, you could move your event date into the sheet summary, and reference it there.

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

OshaK

@Carson Penticuff thank you for letting me know!

Andrée Starå

Hi @OshaK

I hope you're well and safe!

To add to Carson's excellent advice/answer.

As a workaround, you can also use the INDEX function to reference a specific row and still be able to convert it to a column formula.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!