If Comment is not blank, then show the recent comment and date

Hi @bea.sun

Check if this (not perfect) solution will work for you :

Please follow these steps:

(1) Create 2 additional columns (I named them: Follow Up Date if comment and most recent comment)

(2) Make column formula in Follow Up Date if comment:

=IF(ISBLANK(Comments@row), "", [Follow Up Date]@row)

(3) Type formula into cell: Parent row and Follow Up Date column (circled red):

=MAX(CHILDREN([Follow Up Date if comment]@row))

(I could not understand correctly what you meant by "the most recent Follow Up Date", you may check if changing MAX to MIN would do what you want)

(4) Make column formula in most recent comment:

=IF([Follow Up Date if comment]@row = PARENT([Follow Up Date]@row), Comments@row)

(5) Type formula into parent tow Comment column:

=JOIN(CHILDREN([most recent comment]@row))

So as I said earlier this solution is not perfect for a number of reasons but it may be a starting point and we can go from there if you want.

Please let me know how it works.

Thanks!