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
-
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
-
Try using @cell references...
=COUNTIF([% Complete]:[% Complete], AND(@cell <> 0 , @cell <> 1))
Answers
-
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
-
Try using @cell references...
=COUNTIF([% Complete]:[% Complete], AND(@cell <> 0 , @cell <> 1))
-
YES!!! Both seem to work. Thank you both! Was banging my head against the wall of my home office.
-
Happy to help! 👍️
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.6K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!