Grouping data by Email/ ID in a sheet
Hi all,
I have sheet, which holds the information for same ID/ Email for around 12 times, which was being captured at several times points during a year (probably once a year). Is there any way to group one participant information together, apart from creating filters? Can someone please help me with any workarounds that are possible?
Thanks!
Best Answer
-
instead of using filters how about using sorting. You can have up to three conditions when you sort. Out side of that I can’t really think of anything else. Depending on the information you could also do a summary sheet and pull the information you want to it. Like counts or percentages
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Answers
-
instead of using filters how about using sorting. You can have up to three conditions when you sort. Out side of that I can’t really think of anything else. Depending on the information you could also do a summary sheet and pull the information you want to it. Like counts or percentages
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Thank you so much for the response.
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