COUNT/DISTINCT/COLLECT question

I've read the Q&A on these functions but i still can't get mine to work. I'm evaluating two columns: pkg_num, and subprojectorder, then want a count of the Distinct project numbers that meet that criteria

=COUNT(DISTINCT(COLLECT([project_number]1:[project_number]28), [pkg_num]1:[pkg_num]28, ="CD01", subprojectorder1:subprojectorder28,>0)))

So it should return 7

Any advice?!? πŸ˜“

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!