pulling data from multiple columns at once

I have a master equipment sheet with different projects on it.

I'm using a form to collect the information from the lightest orange fields because it's the easiest option for my auditors to use when they're in the field.

I would like to get that information back to the original sheet. I know I can use an INDEX/MATCH formula using the name column as the identifier, but is there a way to do it where I don't have to write a separate formula and create a new range for each entry? Perhaps a JOIN/COLLECT formula column on the audit sheet?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!