Trigger reminder on absence of comments

02/03/20
Answered - Pending Review

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

Answers

  • Paul NewcomePaul 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.
  • 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 NewcomePaul Newcome ✭✭✭✭✭

    Happy to help! 👍️

Sign In or Register to comment.