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

  • Purnima Gore
    Purnima Gore ✭✭✭✭✭✭

    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

    https://www.cierr.com

  • PKane
    PKane ✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!