SumIf question


Hey folks. I'm trying to sum the contents of the column (JobSite Hours) if a certain contact is selected on an adjacent column (Special Conditions). The special conditions column is in fact set up as a contact. my formula works if only one contact is chosen, but the special conditions column is a multi select cell. If there are more than one contact selected, my formula won't work correctly. Any help?

=SUMIFS({FW-MWS Jobsite Hrs}, {FW-MWS Special}, [Sigma Design]$5)

FW-MWS Jobsite Hrs is the column on another sheet for JobSite Hours.

FW-MWS Special is the Special Conditions column that is a multi-select contact column

]Sigma Design$5] is a cell within the sheet I'm working and the contact name I'm looking for.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!