How to copy the latest comment in a row to a cell?

summetg

Hi all,

I'm building a new sheet where we want to use the comments function, but I'd like to have a "read only" of the latest comment left by a user and with the time a date in a cell. This would help summarize the latest detail on a report or a first look at the sheet, and then if they want to check the history they can go into the comments tab.

The intention would be to be a quick update summary in 1 row. Any ideas on how to achieve this? I did a few searches and it seems like it could be an enhancement request

Mike TV

@summetg

I'm not sure it's possible to find the most recent date AND time. If it were just the date you could use the MAX command to find the most recent but that only returns the date and not the time even if you MAX a system generated Created (Date) column.

summetg

What about the latest comment - can that be copied into a row?

Andrée Starå

Hi @summetg

I hope you're well and safe!

I recently developed a solution for a client for this using the 3rd-party service, Zapier.

Is that an option?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

summetg

Sorry I do not!

Andrée Starå

@summetg

What do you mean? Isn't it an option?

summetg

Hi,

So what I'm looking for is that if I enter a comment on a row, that it also gets copied into a cell in the row I entered it in, preferably with a date/time stamp: Here's an example of entering a test comment:

Then you can see the preview in the cell with the date and user name:

This essentially preview the latest comment only and if the user wants to see the history, they can review the history using the comments functions.