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?
Answers
-
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.
-
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!