Examine range, find specific value in a row, then return the value two columns over?

Dennis M Wierzbicki
Dennis M Wierzbicki ✭✭✭✭✭
edited 05/18/22 in Smartsheet Basics

I’m trying to do something with Smartsheet, and getting a little lost in the complexity. What I want to do is examine a range of cells, look in a row, find specific text (entered from a 38 item pick list), then return the value that is 2 columns/cells over from the found text, then SUM all such values found. I think an INDEX/MATCH might accomplish this, but I’m not that fluent in using this feature.

Best Answer