Trigger reminder on absence of comments

Hi,

It looks like the "modified" column doesn't update when a comment is added to a row. Comparing this date/time value to today's date/time value is the only way I see to automate a reminder when a row has not been updated (and by updated, I mean a comment left on the row, not a cell changing).

example - remind 'assignee' to update row when modifed <= (today - 5 days))

questions:

am i correct that a comment doesn't initiate an update to the modified date column?
is there any other way that I can use a comment being added in a workflow condition?

Thanks

Find more posts tagged with

functionality

Comments and Conversations

Workflows in Smartsheet

Accepted answers

All comments

Paul Newcome

You are correct.
You would need to have the person making the comment update a cell to enter the date or use a 3rd party tool such as Zapier.

jk99

Thanks very much!

I have suggested in the past for a column type or formula that allows for the display of the most recent comment in a cell of the respective row. That would be another way to make this work.

Paul Newcome

Happy to help! 👍️

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.