Cancel this. It's working. Long day.

Options
BeCus
BeCus ✭✭
edited 03/03/23 in Formulas and Functions

=COUNT(COLLECT({Initiative}, {Initiatives Target Qtr}, $Label$10, {Product Category}, " "))

I'm trying to count those with a an empty Product Category cell in a particular quarter. I get 0 every time even though I know there are 6.

I've tried changing the order, no difference.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!