Seeing #UNPARSEABLE issue when applying formulae in the summary
Here is the formula I have
=COUNTIFS([Level]: [Level], 1, [Status]: [Status], NOT(OR([Status]@cell= "Not Applicable", [Status]@cell= "Canceled")))-COUNTIFS([Level]; [Level], 1, [ECO Workflow]: [ECO Workflow], "ECO Implementation", [Status]: [Status], "Completed")
I have cross checked spellings and quotations, could any help me to find the Issue.
Note: I took help of the Generative AI tools in Smartsheet to create the formula.
Best Answer
-
Give this a try:
=COUNTIFS([Level]: [Level], 1, [Status]: [Status], NOT(OR(@cell= "Not Applicable", @cell= "Canceled"))) - COUNTIFS([Level]:[Level], 1, [ECO Workflow]:[ECO Workflow], "ECO Implementation", [Status]: [Status], "Completed")
The most obvious issue I see is a semicolon in place of a colon in your original formula.
Answers
-
Give this a try:
=COUNTIFS([Level]: [Level], 1, [Status]: [Status], NOT(OR(@cell= "Not Applicable", @cell= "Canceled"))) - COUNTIFS([Level]:[Level], 1, [ECO Workflow]:[ECO Workflow], "ECO Implementation", [Status]: [Status], "Completed")
The most obvious issue I see is a semicolon in place of a colon in your original formula.
-
Worked, Thanks Carson
Appreciate your guidance!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!