sum hours of an assigned to, in a multi contact column
Angela.R
✭✭✭
=SUMIF([Assigned To]:[Assigned To], =[Assigned To]@row, [Hours Testing]:[Hours Testing])
Works great, if the "assigned to" is only a single person.
When there is more than one contact in the cell, it is unable to find.
I'd like to not have a name spelled out in the formula eg "Jane" I'd rather it look to =[Assigned To]@row. that way if the user in that cell changes, it will automatically update the new total hours.
If Jane and Kara are listed in the "assigned to" my formula above doesn't included.. Only when it is a single contact. appreciate the help and what updated formula i should be using.
Tags:
Best Answer
Answers
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 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!