Filter comments that include my name
How can I filter or sort comments so I only see the ones with @myname? My team asks tons of questions via smartsheets (one giant sheet with hundreds of entries) and it is very hard to keep up with all the comments and make sure we don't miss anything.
The email notification with link to the link isn't enough. I want each person to be able to look holistically.
thanks
Answers
-
@samie9876 There are two approaches you could take to accomplish this. The first would be to export the data to excel. On the second sheet in the excel file it will export all of your comments that are attached to the sheet. They are placed in row order and then date order. So all of row 1's comments will be together. You could then just apply a filter to show the ones with your name in it:
The second option would require a little bit of due diligence on your team's part to make sure they use tagging on questions in the conversation. There is a column type titled "Latest Comment." You could add that column to your sheet and it displays the last conversation note listed. You could then build a filter around that column that uses the "Contains" option and use your email address as the text it looks for. But again, this will only show the last comment made. So if they are seeking advice from you they will need to @ your name and then wait until you respond. Etc.So your filter would be something similar to:
Make sure you use the @ symbol, otherwise it will include all of your responses, too.
And the filter would produce a result such as this:
I hope that helps you get some resolution!
-Brian
-
Brian, thank you. The first is not an option since comments are being posted all the time and we need a live solution. I will try your second idea. Everyone is VERY diligent about @'ing. It's just keeping up with it all that is the challenge.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 432 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives