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
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!