CONTAINS in COUNTIF referencing to another sheet returns #UNPARSABLE.
I want to count all the cells with the word "Exempt" in the Column/Reference {Stat}. Using the formula below gives me the #UNPARSABLE error.
=COUNTIFS({BIN}, [BIN #]@row, {Stat}, CONTAINS("Exempt",{Stat})
=COUNTIFS({BIN}, [BIN #]@row, {Stat}, CONTAINS("Exempt",{Stat}@cell)
=COUNTIFS({BIN}, [BIN #]@row, {Stat}, CONTAINS("Exempt",{Stat}@row)
However, this one works, but does not count the all varieties of Exempt items in the column:
=COUNTIFS({BIN}, [BIN #]@row, {Stat}, "Exempt Unit(s)")
...
Answers
-
Since you're already supply the second criteria range ({Stat}), you don't need to list it again in the CONTAINS. Use @cell by itself. Also, you need a second end parentheses on the end of the formula, since you have to close off your CONTAINS function as well as the COUNTIFS formula.
=COUNTIFS({BIN}, [BIN #]@row, {Stat}, CONTAINS("Exempt", @cell))
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives