Filtering the sheet according to leftmost system column content: Comments, Attachments, Proofs, etc.

Eddie

Hello,

I need to put a filter to the sheet to see only the rows including "Comments" (Comments in conversation, not comment column added manually). The question may be extended to filtering:

·        Locked rows,

·        Including proof rows,

·        Including attachments,

·        Update requests,

·        Etc. (whatever available in the first (leftmost) system column))

It should be available in the leftmost system column's three-dots (kebab) menu of each item but it is not there. There is only "Hide menu" option without any filtering feature.

Thanks.

Jen Lange

Hi @E.B. The ability to filter your sheet by conversations isn't available in the column right-click menu; however, if you create a sheet filter for the row to only display rows that "has comments", I think you'll achieve your goal.

Let me know if this is helpful. Thanks!

-Jen

Jen Lange

Hi @E.B. The ability to filter your sheet by conversations isn't available in the column right-click menu; however, if you create a sheet filter for the row to only display rows that "has comments", I think you'll achieve your goal.

Let me know if this is helpful. Thanks!

-Jen

Eddie

Hi @Jen Lange ,

Thanks for your support. Your answer perfectly solves my problem. Indeed, it's better than I expected because I can create and save my filters for the long run.

It was surprising for me that I overlooked the "row" option in the new filter menu. I think this is because when you click on the pop up menu, the cursor is already on the "row" and the right-side selections are empty. That's why I thought it was the main menu. If the current position were empty and "row" option were in the second line, definitely it would be more eye-catching. Anyway, thanks a lot for your great support.

Regards,

Jen Lange

That's great. @E.B.

Also, thank you for your engagement and contribution to our community. Your inquiry is likely to assist other members across time AND it helps me flex my skills.

-Jen