Index/Match vertical Report
Hello,
I have a form for people to submit dinner menus for themselves and for up to 11 guests (but there would be 12 children as the primary contact meal would be a child as well), plus drinks. This forms feed into a sheet that has 74 potential columns of information. As you can imagine, it is too large to really see anything.
I found this thread - https://community.smartsheet.com/discussion/86632/create-report-with-text-from-multiple-columns-but-stacked-vertically-in-rows and attempted to build a separate sheet to create vertical report.
Ideally, the new report would look like this
I created the helper column but then got stuck trying to pull through the other information. I tried using this formula =INDEX({UB23 - Guests and Food Range}, MATCH([Primary Contact]@row),{Helper Column},0), MATCH([Primary Column]@row,{Top Row},0)). With no luck.
Any help/information you could provide that would be great.
Thanks
Answers
-
Aimee,
At what point are you getting stuck? Would you be able to just use the group by within the reporting feature to eliminate the helper column? See example below.
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 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
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!