Formula to return the SUM of prices from a cell with multiple values (multiselect column)

montserrat ✭✭
edited 11/16/23 in Formulas and Functions


I'm sure someone has encountered this issue before so hopefully there's a work around it.

We have a tracker with multiple service requests. We document each request in a very detailed way here. We already have a lot of columns here, so adding more than 2-3 is not an option.

From a multi-select column named "Transaction", users can select from a long list of transactions names as many as they need. Each transaction has a different price. I need to build a formula that SUM the prices of all the transactions selected, searching in a helper sheet for the price associated with each transaction.

Is there a mix of functions that could help me achieve this? I was thinking that maybe COLLECT with VLOOKUP but not sure if they work together.

Any guidance would be wonderful.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!