Invalid Data Type error
DanielGD
✭✭✭✭
Getting an Invalid Data Type error with this formula:
=COUNTIF(AND(FacilityCount:FacilityCount, "TZ"),NOT(COUNTIF(Status:Status, "Green")))
The second "CountIf" is a symbols column.
Looking to make a count of certain 2-letter codes if the status column does not have a "Green" ball.
Thanks
Comments
-
Try this instead.
=Countifs(FacilityCount:FacilityCount, "TZ", Status:Status, <>"Green")
Countifs checks against multiple criteria and ranges.
<> means "does not equal" so count every facility with TZ that does not have a status of green.
-
Works perfect. Thanks. I missed the difference between COUNTIF and COUNTIFS.
-
You're welcome! Glad I could assist.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!