Not able to get Countif to work with Contains
I have sheet that has a column called Legal Tasks. I'm trying to write a Countif formula that counts the number of times the word in Column2 appears in the Legal Task column.
As the formula stands it is trying to do an exact match, however my intent is to include in my count everytime the word appears by itself or with the some others.
In the screenshot the {Employee-LegalTask} range is the entire Legal Task Column.
Any help appreciated.
Comments
-
Try this formula. I got it to work within a sheet. It should work with cross sheet references as well.
=COUNTIF({cross sheet reference}, FIND("One", @cell) > 0)
-
*Note: You might have to recreate that cross sheet reference.
-
Could not get it to work.
I'm using this:
=COUNTIF({Employment-LegalTask}, FIND(Column2@row, {Employment-LegalTask}) > 0)
-
Try this: =COUNTIF({Employment-LegalTask}, FIND(Column2@row, @cell > 0)
-
I'm getting the INVALID DATA TYPE error. See the attached images.
-
Please see me comment below.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives