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
-
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")))
Answers
-
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")))
-
Amazing, thanks David - that sorted it!
-
Awesome! Glad it is working.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!