How to count incomplete tasks using % Complete?

Hi, I've got a project I've imported from MSProject, and my smartsheet has a % complete column. I'm trying to use COUNTIF to identify the number of tasks that are unstarted, those that are complete, and those that are in progress using that % Complete. I can get the first two to work, but I'm having trouble with the in-progress ones. I'm using the following formula:

=COUNTIF([% Complete]:[% Complete], AND([% Complete] <> 0 , [% Complete] <> 1))

and it's coming back as "unparseable".

Can somebody help me? I appreciate it!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!