Display most recent comment of Child Rows in parent row.

Options

Hello,

I'm looking for assistance in creating a formula that could be applied to a whole column that would display the most recent comment of a child row in the parent row. This would help to see the most recent update to a project at a glance in reports. After the screenshot, I made another column to collect the data, but I need some assistance setting up the formula.



Answers

  • Devin Lee
    Devin Lee ✭✭✭✭✭
    Options

    The way I would go about doing it is to add a Comment Date column and then create an automation that records the date when a comment is made.

    In the cells of the parent rows of the Comment Date add =MAX(CHILDREN()) which will pull up the latest date a comment was made in the children rows.

    In the cells of the parent rows of the Latest Comment add =JOIN(COLLECT(CHILDREN(), CHILDREN([Comment Date]@row), [Comment Date]@row), " _ ") which will look for any comments that matches that date and join them together. This is to avoid the issue of multiple comments happening in one day and not seeing them all.

    There is probably a more complex way to create column formulas but I would only go down that road if you have a ton of data and picking out all the parent rows is a pain.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!