Invalid Data Type error
Options
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!