Using Collect with count if and count if NOT


I have the following formula I'm trying to run

=COUNT(COLLECT({Target Live Date}, {Checkbox}, "1", {Type}, "Native", {Status}, NOT "Published"))

Count cells with a target live date, where the checkbox is ticked, the type is native, and the status is NOT published.

All seems to be working well until the NOT part. Any clue how to do this?

Thanks all :)


Best Answer

  • David Tutwiler
    David Tutwiler Overachievers Alumni
    Answer ✓

    I think you just need to close the "Published" in ( ) and it will work. NOT is a function in Smartsheet so you need to pass it parameters.

    =COUNT(COLLECT({Target Live Date}, {Checkbox}, "1", {Type}, "Native", {Status}, NOT("Published")))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!