I'm trying to use CONTAINS, MATCH, and INDEX in cross-sheet formulas to pull location-specific system component inspection information from invoices to my asset register.

Sometimes, the invoices will have more than one system component on them.

I want to make sure the formulas will pull the information for each of the system components. In the attached screenshot on line 11, I would get the result "2/28/19" for both 01-Jan and 02-Feb Extinguishers.

I've created a column that concatenates the location and system component but I'm not sure that's going to work for the invoices that have multiple components.

Any thoughts?

FLS Invoice Register.jpg


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!