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!

Find more posts tagged with

Accepted answers

Debbie Sawyer

Hi Thomas

I have re-produced your issue here and hopefully provided you with an answer

The function I used for the How many in progress row was:

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

Hope this helps :)

Kind regards

Debbie Sawyer Consultant & Training Manager

RaFLZADwxPlIdaUSlkVwf4pKuVBIBnNkQjN9U6RSHg8na7ayJNR2BK6IKWyXZ8c2uUWi-gGwDnUQrryXTDiBx8kyRSnEjBqvEnmOJAIGq17AnBPTtcbK5oXRBb2IUcqChOToQtr4

Paul Newcome

Try using @cell references...

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

All comments

Debbie Sawyer

Hi Thomas

I have re-produced your issue here and hopefully provided you with an answer

The function I used for the How many in progress row was:

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

Hope this helps :)

Kind regards

Debbie Sawyer Consultant & Training Manager

Paul Newcome

Try using @cell references...

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

Thomas Yonker

YES!!! Both seem to work. Thank you both! Was banging my head against the wall of my home office.

Paul Newcome

Happy to help! 👍️

Debbie Sawyer

Ha ha - @Thomas Yonker I know that feeling well!!

Glad to have helped too :)

Kind regards

Debbie

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.