Hi folks, I’m wondering if there is a way to mark a row as modified when I add additional notes from a related “Tasks Notes” table?
I was looking for the Task updates one of my team members added this morning to the “Team Tasks” tracker I created for my company’s group:
When I changed the “Modified” interactive filter I have for the table for “Today”, nothing displayed - as the image shows, she clicked the + Note button which opens up a row in the related “Task Notes” table, added her notes marked “5/1” and the Task Note displays correctly in the Team Tasks table.
However the updated row still shows the row as being last modified when the table row itself was last changed on 04/28?
In my mind, adding a new Task Note to a row in its related Tasks table should tickle the modified time for that row since something was actually added to that row?
Is there way in the Add Note button formula I can somehow get the Modified timestamp of the Tasks table to become updated after a new related Task Note is added?
Any suggestions are appreciated (I also have related “Sub-Tasks” column that are added to the row in a similar fashion…)