Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Hi,
I am trying to use COUNTIF for counting number of projects with "At Risk" flags turned on. I get #UNPARSEABLE for this- COUNTIF(At Risk:At Risk, 1). Any feedback appreciated. Thank you.
Hi Ginny,
Any field name that contains spaces needs its name to be referenced in square brackets:
=COUNTIF([At Risk]:[At Risk], 1)
Cheers,
Rob.
Hello,I am trying to do the same task mentioned above. But when I use the =COUNTIF([At Risk]:[At Risk], 1) formula, I get an error that says #BOOLEAN EXPECTED. What does that mean and how do I fix it?
Wendy,
The error is telling you that you are trying to enter a number greater than 1 in a Checkbox type column.
You can do that, but not as a number.
=COUNTIF([At Risk]:[At Risk], 1) + ""
will display a number, but it will be text.
If you later want to use that somewhere else, you can turn it back into a number using the VALUE() function.
Be aware that the COUNTIF() formula above as written can not be in the [At Risk] column -- you will get a circular error.
I hope this helps.
Craig
