Filtering for comments

danbroun

I want to filter my tasks by comments. So I want to see all tasks which contain the snippet "asdfasdf" in the comments. I am not able to make the filter work. I tried it with Comment -> contains -> asdfasdf and Comment is equal to asdfasdf. Unfortunately both does not work...

Chris McKay

Hi,

Just to be clear, are you referring to the:

1. Comments column to the far right of the default Project template, or;
2. Comments column that appears in all sheets (between the Attachments and Row Action Indicators columns) to the far left?

If it is option 1, then what you attempted with Comment -> contains -> asdfasdf is correct and will work.

If it is option 2, then you're out of luck because this system Comments column cannot be filtered.

Kind regards,

Chris McKay

P.S. Dear Smartsheet,

Seriously, who in your Product Team thought that naming these columns the same thing by default was a good idea?

danbroun

Alright now I see...

Doesn't make much sense but now I know how it works.

 

Thank you so much!

Chris McKay

My pleasure. I agree that it doesn't make much sense.

Mattias

One more of the things I run into then that has the "dont make sense" stamp on it.

Is there a reason for not being able to filter on this column in reports?

Eddie

Hello,

@Jen Lange has the solution:

https://community.smartsheet.com/discussion/79722/filtering-the-sheet-according-to-leftmost-system-column-content-comments-attachments-proofs-etc

L. Alexander

It would be very useful to create a filter which would show issues in which I (the current user,) was @mentioned in the comments for the issue.

CycleBagEd

IMHO:

The "latest comment" field should always be there, like a system column. At the moment it only shows if you choose to add it. This is a missed opportunity, and would allow filtering.

Having a set of pre-set admin controlled tags to add would also be good and add another dimension of information to Smartsheet. Seems like an easy win.