My proposed solution does not use the [Last Modified date] of the Parent. It it fits obtains the last Modified date of all tasks for that project to identify the tasks which has the comment we need. Then we look that up down to all task records to be able to have a tier summary field, of the combined text from all tasks records (probably just 1 Record) where that lucky task is the one that matches as being the most recently modified task.
i suppose that summary field could also be modified to only summarize tasks which do that a non blank comment.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commarkshnier2@gmail.com
------------------------------
