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

summetg
summetg
edited 05/04/22 in Formulas and Functions

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

  • Mike TV
    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.

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

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 05/06/22

    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.

  • Sorry I do not!

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    @summetg

    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.

  • 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.