Lookup with Multi Select Column


Hi. I have a Smartsheet of "capabilities". For each capability, someone can select multiple "investments" that support that capability. So you might have:

Capability1: MyCapability

Investments: App1 Hardware1

Each capability could have 1 or dozens of investments. I have another sheet with these investments in it and their cost

App1 $10

Hardware1 $20

I want to look up each investment for MyCapability and return the sum of the total cost $30.

Is this possible?

Any help would be much appreciated.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!