Filter for unread or new conversation

Hello All

I have a sheet with hundreds of development items. Our team communicates in the row conversation panel instead of email.

As the PM I am looking for a way to provide a filter list to show me only rows that have a new or unread comment in the conversation.

Is this possible?

Right now I am just scrolling through hundred of items looking at the left side conversation icon with any with a red dot.

Jeffrey McMillan CAPM, PMP

Project Manager, Financial Applications ERP

Answers

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭

    There is an unread option under Conversations on the right panel.


  • Matt Johnson
    Matt Johnson ✭✭✭✭✭✭

    Hi @Jeffrey McMillan

    For unread messages you can click on the Conversation icon on the upper right. Then choose Unread in the Conversations panel.

    Here's an idea for recent comments:

    • Add a new column with the type of "Latest Comment".
    • Then add a new date column for Latest Comment Date.
    • Next add an automation that records the date any time the Latest Comment column changes.
    • Last, either make a filter or create a report that only shows rows where the Latest Comment Date was changed in the last 2 days or something like that.

    I hope that helps.

    Matt

    Matt Johnson

    Sevan Technology

    Smartsheet Aligned Partner