Conditional formulas with multi-select contact list

Alex Fullerton
edited 09/08/22 in Formulas and Functions

I have a formula like this with a cross-sheet reference:

=SUMIF({Owner Range}, Owner@row, {Sum Range})

where Owner is a contact and Owner Range is a multi-select contact list. Some cells have multiple contacts in them and do not count towards this sum. How do I create a formula that will sum any cell containing Owner@row?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!