Only count items that aren't marked "complete" in the status column.
Hello All,
I am hoping someone might be able to help me w/ my formula? I'd like it to only count items that aren't marked "complete" in the status column. This is what I have so far:
=COUNTIFS({Remediations Category}, "NEC VIOLATION - ARC FLASH FAILURE", {Remediations Core OPCO}, "NSP", {Remediations Year}, "2022", {Remediation Status} I am not sure what to do here)
Any help or advice with this would be great - thanks in advance!
Answers
-
Hi
You can use the <> which means Not in the formula
=COUNTIF(Status:Status, <>"Complete")
Let me know if that helps :-)
Kind regards
Purnima
Project GPS
Purnima Gore
Cierr Limited
Your Time is Important, you want to Stay on Track, We can help you use the Right Tools
-
Thank you very much, Purnima for your reply! I am pretty new to formulas, and wanted to ask -
Should the formula look something like this?
=COUNTIFS({Remediations Category}, "NEC VIOLATION - ARC FLASH FAILURE", {Remediations Core OPCO}, "NSP", {Remediations Year}, "2022", {Remediation Status} Status:Status, <>"Complete")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!