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.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!