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

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!

Find more posts tagged with

Dashboards

Comments and Conversations

Accepted answers

All comments

JamesB

@Jmalthouse

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

@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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.