Report to itemize responses
Hello! I am trying to develop a report that will list out which Residents have selected which Attendings with whom they have worked - here is the sheet that comes from the form I've created - they just click the box for which ones they've worked with. I then want to be able to have a report that lists each Attending with the Residents underneath (ie Dr. Miller would have John Smith and Mike Jones listed beneath him, not just "2"). Is that possible to do?
Best Answers
-
You want it in a single cell below the results?
=join(collect([Resident Name]1:[Resident Name]3,Miller1:Miller3,@cell = 1),", ")
If you want the names in individual cells you can use index(collect()) in the same format as above.
-
Thank you!!
Answers
-
You want it in a single cell below the results?
=join(collect([Resident Name]1:[Resident Name]3,Miller1:Miller3,@cell = 1),", ")
If you want the names in individual cells you can use index(collect()) in the same format as above.
-
Thank you!!
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!