Seeing #UNPARSEABLE issue when applying formulae in the summary

Kiranb

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.

Carson Penticuff

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.

Carson Penticuff

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.

Kiranb

Worked, Thanks Carson
Appreciate your guidance!