Countifs with Contains function
Hello,
I am having trouble with this formula. Basically we have a list of employees with a column for their position, and their schedule. If they are in training, the schedule starts with "Effective" followed by the date they leave training. I am trying to pull the number of people in each position that are in training by locating the partial text. Below are two formulas I'm trying out but neither are working, any suggestions?
=COUNTIFS({Team Sheet Range 1}, Position@row, {Team Sheet Range 2},"Effective")
=COUNTIFS({Team Sheet Range 1}, Position@row, CONTAINS("Effective", {Team Sheet Range 2}))
Best Answer
-
=COUNTIFS({Team Sheet Range 1}, Position@row, {Team Sheet Range 2}, CONTAINS("Effective", @cell))
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
=COUNTIFS({Team Sheet Range 1}, Position@row, {Team Sheet Range 2}, CONTAINS("Effective", @cell))
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 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
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!