COUNTIFS/CONTAINS - Identifying Placeholders
Hello!
I am working on getting metrics to identify how many upcoming tasks (next 30 days, etc) have placeholders (from Resource Management) assigned to them rather than a specific contact. There doesn't seem to be a way to identify a placeholder from a contact so I have been attempting to use COUNTIF(CONTAINS.. function statements and using words that are in the placeholders. For example, contains "Manager" because we have several Placeholder roles with the word Manager in them.
Nothing is coming up even though the criteria matches. Any ideas? Will the contains not pick up words in a placeholder? Is CONTAINS not the correct function to use? I tried HAS also, but wasn't successful...
Thanks for your ideas and insights!
Answers
-
Thanks @Devin Lee - that is exactly the formula I am using and it's not working...
-
Are you able to give a screenshot of the sheet or share it so we can get a better idea of how the sheet is structured?
Help Article Resources
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
Check out the Formula Handbook template!