How do I sum a range for a contact when the contact is in a column that allows multiple contacts?
I tried =SUMIF(Owner38:Owner59, Owner@row, Duration38:Duration59) but this only works if the Owner is the only name selected in the cell. If the Owner is included with another name in the cell it doesn't find the owner.
Formula returns 2 instead of 12
Best Answer
-
Thanks @Nic Larsen and @Mark Cronk that did the trick.
Answers
-
You can try something like this:
=SUMIFS(Duration:Duration, Owner:Owner, FIND("Owners Name Here", @cell) > 0)
or
=SUMIFS(Duration:Duration, Owner:Owner, FIND(Owner@row, @cell) > 0)
-
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Thanks @Nic Larsen and @Mark Cronk that did the trick.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 392 Global Discussions
- 214 Industry Talk
- 447 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!