Sumifs with dynamic criteria from multi-select dropdown

I have Sheet 1, having rows where a record can be assigned values from a Multi-Select Dropdown with Requirement IDs (REQ1, REQ2, REQ5).

I have a separate, Sheet 2 with Requirements. Each Requirement has an ID and a Weight.

ID, Weight

REQ 1, 5

REQ2, 5


REQ5, 3

I want to assign REQ1, REQ2, REQ5 to a record in Sheet 1 and write a Sumifs formula that returns the total Weight, from Sheet 2 as = 5 + 5 + 3 = 13.

Any tips?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!