Furmula Not Working Properly
In the following Formula if I use ="Completed" I get the correct Count back. If I change it to <> "Completed" I get 0 returned where it should be 37.
=COUNTIFS(Status:Status, <>"Completed", [Due Date]:[Due Date], >DATE(2018, 11, 25), [Due Date]:[Due Date], <DATE(2018, 12, 3))
Any ideas?
Thanks,
Bill
Comments
-
I was wrong, = is returning a value but not the correct one.
-
Are you looking for a "Not Equal To" Function?
If so, try the NOT() modifier. It'll look like this:
=COUNTIFS(Status:Status, NOT(@cell="Completed"), [Due Date]:[Due Date], >DATE(2018, 11, 25), [Due Date]:[Due Date], <DATE(2018, 12, 3))
The =@cell is there as a concrete reference to the cell being evaluated.. you may not need it.
Hope it helps!
-
Thanks, I was mistaken the = is working. I will try the NOT(@cell="Completed"),
-
Thanks, that did it!
-
Great to hear!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!