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

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
Answers
-
What about the latest comment - can that be copied into a row?
0 -
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
0 -
Sorry I do not!
0 -
What do you mean? Isn't it an option?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
0 -
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.
0