How do I reference a whole column in the count function?


Hi. I'm trying to count how many projects have a status of "not started". The column with status is in a different sheet. How do I reference the whole column in the formula? I keep getting unparseable. I tried =COUNT(COLLECT({status}1:{Status}21, {status}1:{Status}21, ="Not Started"))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!