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:
- 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
Answers
-
- 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.
-
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.
-
Happy to help! 👍️