I keep getting #UNPARSEABLE when I use this formula. What am I doing wrong?
Here's the formula: COUNTIFS(Successors:Successors, HAS(@cell, Rownum@row), [% Complete]:[% Complete], OR(ISBLANK(@cell), @cell < 1)) = 0
Answers
-
Hello @Liz Christensen
Your function looks like you are trying to count specific values, but then check to see if they're equal to 0.
Is there more to the function? This looks like it could be a conditional statement that is part of another function.
If you remove the "=0" at the end, the function will count the values.
With the =0, I believe the return value will be either True or False. In this case, the column property needs to be a boolean like a checkbox.
-
What are you attempting to accomplish with this formula? It makes sense until you get to the = 0 at the end, that part has me confused.
-
I agree. Knowing the end goal of the formula would be very helpful in troubleshooting.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!