Using Collect with count if and count if NOT

Anna Keeton

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 :)

David Tutwiler

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")))

David Tutwiler

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")))

Anna Keeton

Amazing, thanks David - that sorted it!

David Tutwiler

Awesome! Glad it is working.