Including Contact Criteria in SUMIFS Formula
Hi!
I am attempting to include a Contact Name as criteria in a SUMIFS formula.
I'd like to sum Claire RobertsonKraft's "September Actual Hours" for the "Red & Blue Exchange" project.
I've written this formula (below) and it is returning the #CONTACT EXPECTED error. Does anyone have any advice on how to fix it?
=SUMIFS([September Actual Hours]:[September Actual Hours], Project:Project, ="Red & Blue Exchange", Who:Who, ="Claire RobertsonKraft")
Thank you!
Best Answer

What type of column or Summary field are you putting this formula into? Since the output of that formula is a number (the SUM of the Hours column), then the CONTACT EXPECTED error can appear if you're pasting this formula into a contact field instead of into a text/number field. (See here for more on the error.)
Try pasting the exact same formula into either a Text/Number column or into a Text/Number field in your Sheet Summary. Let me know if that works!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
Answers

What type of column or Summary field are you putting this formula into? Since the output of that formula is a number (the SUM of the Hours column), then the CONTACT EXPECTED error can appear if you're pasting this formula into a contact field instead of into a text/number field. (See here for more on the error.)
Try pasting the exact same formula into either a Text/Number column or into a Text/Number field in your Sheet Summary. Let me know if that works!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now 
Genevieve, that fixed it! Thank you so much for your help!!

Great!! No problem at all 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!