Summing Multi-Dropdown Values
I have a Smartsheet with a multi-dropdown where people pick multiple tests to be run. Each of those tests has a cost that I have on a different sheet. With one selection in the test column it's easy enough to do a VLOOKUP to grab the value. Is it possible to parse through multiple entries in a cell, grab their individual costs from a table using VLOOKUP (or something else), and sum them? Or do I just need to create separate VLOOKUP columns for each test?
Help Article Resources
Check out the Formula Handbook template!