Show the latest comment, if posted within the last week on dashboard

edited 10/19/23 in Smartsheet Basics

Hi SU Community,

I received some feedback from our CEO on our last meeting. He would like to have a simple visual all of the latest comments for all of our projects - if they were created within the last week. He is not picky about the way this information is given (Dashboard, report, email update, etc).

It should show: Project Name, Comment (within 1 week only), & who left the comment.

I have tried to make a report, but I could not make the filters work to only show comments left within the last week. Is anyone able to help me brainstorm a way to provide this?

Thank you!


  • JamesB
    JamesB ✭✭✭✭✭✭


    I have done something similar to this. I created a helper date column named comments last updated. Then I used an automation to set the date in that cell when the comments cell changed. With this you can filter based on this helper column.

  • JamesB
    JamesB ✭✭✭✭✭✭

    @Jmalthouse Please note that my first comment was in relation to a column named comments. There is also now a latest comment column type. This pulls in the comment data from the conversations section.