Trigger reminder on absence of comments

jk99

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:

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

Thanks

Paul Newcome

1. You are correct.
2. 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! 👍️