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?

Find more posts tagged with

Sheets

Formulas

Accepted answers

All comments

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.

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

Combine Master and Input in a Report and Group and Summrize.png

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.