NEW Contains formula
I am trying to use the contains formula within a SUMIF (see below). This does not seem to work and I can not figure out why. It seems as though all the examples that are provided, CONTAIN is only used within IF formulas. Is this the case?
My formula:
=SUMIFS({Employee Tasks Range 1}, {Employee Tasks Range 2}, CONTAINS([ResourceName]$1, {Employee Tasks Range 2}), {Employee Tasks Range 3}, >$[Start Date]3, {Employee Tasks Range 3}, <$[End Date]3)
My formula in english:
= SUMIFS ({the hours allocated for a task}, {for resources in this column}, CONTAIN (resource name, {for resources in this column}), {and the due date} is greater than Sunday of week x and less then Saturday of week x
Comments
-
Try replacing the range in your CONTAINS function with @cell.
-
Bumping this. Can't seem to figure out contains!
-
Which parts exactly are you struggling with? CONTAINS is definitely a weird one to get used to.
I went ahead and started a new discussion HERE pertaining to this function to hopefully collect some knowledge and ideas about it in one place. Feel free to check it out.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 405 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!