pulling data from multiple columns at once

Megan Grant

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?

jmyzk_cloudsmart_jp

Hi @Megan Grant

I am unsure if it fits your needs. Still, an easy way to combine Master and Input data without writing formulas and creating many cross-reference ranges is to combine the Master and Input Sheet in a report and group and summarize.😀

Please take a look at the demo example below.

Smartsheet

https://app.smartsheet.com/b/publish?EQBCT=7ab74c4741d54298afcdd5b8c6f74afd

Megan Grant

Oh wow, now that I see it, it seems so obvious! Of course I know I can pull data from multiple sheets into one report I just never have before because I never needed to.

Thanks so much!