Latest Comment in Cell

@daniel
@daniel ✭
edited 12/09/19 inSmartsheet Basics

Is it possible to reference the latest comment on a row, in a cell?

And if we cannot currently do so, could this be considered an additional feature in the future? I would love to see the latest "update" on a project task as opposed to opening up the comments or manually updating the cell to reflect the latest update.

Thanks.

Tags:
· Share on Facebook Share on Twitter

Best Answer

  • Brian Cunningham
    Brian Cunningham ✭✭
    Answer ✓

    This is possible now! It's just a little tricky to find.

    Just click the comment button so the comment screen appears on the right. Then click the three dots in the top right of that screen. There is an option to "Insert latest comments column".

    image.png


    · Share on Facebook Share on Twitter
«1

Answers

  • MattH
    MattH ✭

    I just want to add that when I'm working internally with teams to help them build their own processes with sheets that's often the only reason they refuse to use the "comments" on a sheet: they'd rather use a single cell to see the latest update and suffer later if they need to review the whole history.

    · Share on Facebook Share on Twitter
  • Marcin P
    Marcin P ✭

    I think that comments on the left hand side are more for conversations about relevant project's row and if you'd like to have kind of last status of the prject, the easiest way would be to create special column for it. Then, if anyone will update it, all team members will see the latest status, but you wil still have possibility to check history of all statuses via View Cell History functionality. At least this is how I would do it:)

    · Share on Facebook Share on Twitter
  • mniblett
    mniblett ✭

    I really like the idea of showing the last comment in a cell (in fact I got top this thread because I was searching on a way to show comments in cells). Obviously, it's easy to add your own comments cell, but them it keeps growing, people don't always add info to ID who made the comment, and people can edit other peoples comments since they have access to edit the whole cell. It would be really good if we could use the comments feature and be able to see the last (if not all) of the comments displayed in a cell.

    · Share on Facebook Share on Twitter
  • Suzanne Fogleman
    Suzanne Fogleman ✭

    I would like this feature as well

    · Share on Facebook Share on Twitter
  • DaveGreen
    DaveGreen ✭

    我这个请求之前因为这是迄今为止the most annoying thing about Smartsheet when managing tasks and needing lots of status updates. (and there are NOT a lot of things that annoy me about SS !!!) Copying and pasting from the Comments dialog into my "Current Status" cell (or vice-versa) is a manual exercise that I can barely stand to do myself, much less expect everyone on my team to do the same.

    But if we keep requesting the enhancement I'm sure they'll eventually hear us!

    · Share on Facebook Share on Twitter
  • TimRyan
    TimRyan ✭

    This seems like it could be a simple formula pull in a row. Can this be added soon please, google has several pages of this request.

    Love smartsheet, however this would round it out perfectly.

    · Share on Facebook Share on Twitter
  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi All,

    I think that this might be possible to set up with the help of a third party tool like Zapier or similar. I'll get back to you if I find a solution.

    Until then,Please submit an Enhancement Request when you have a moment.

    Happy New Year!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

    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.

    · Share on Facebook Share on Twitter
  • Kenny
    Kenny ✭

    Same request. Submitted an enhancement request.

    · Share on Facebook Share on Twitter
  • Mara
    Mara ✭

    This is exactly what I'm looking for. On one hand the interaction with comments is great, but if you need to scan through the latest on a bunch of rows, the last thing you want to do is open the comments bubble for each one.

    At this point, we're debating going back to a "type your updates into a single" cell method, which isn't really what anyone wants.

    Will submit an ER!

    · Share on Facebook Share on Twitter
  • David Woodard
    David Woodard ✭✭

    This would be huge! Would also make it easier to keep track of all status updates and the most recent. Helpful with Project Status Reporting. Can't wait to see a solution. Any progress on this?

    · Share on Facebook Share on Twitter
  • mmoramarco113461
    mmoramarco113461 ✭

    In the process of building out an IT PMO Accelerator instance at my firm. This featureneedsto be available. Perfect way to have a running log of status updates, and managers/executives can see the most-recent updates at a glance in the cell. I'll be submitting an enhancement request presently.

    · Share on Facebook Share on Twitter
  • Chris Rea
    Chris Rea ✭

    Add me to the list of people who would like this feature added. There has to be a way to do this and I definitely don't trust my people to update the same information into two different places accurately.

    · Share on Facebook Share on Twitter
  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    @Chris Rea

    Please submit an Enhancement Request when you have a moment.

    I hope that helps!

    有一个很好的一天!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    work-bold

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

    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.

    · Share on Facebook Share on Twitter
  • Rhonda Mudryk
    Rhonda Mudryk ✭

    Hello - please add me to this enhancement request. I was just searching for a way to add a comment to a cell and found this.


    Thanks!

    Rhonda Mudryk

    · Share on Facebook Share on Twitter
  • Amy McCann
    Amy McCann ✭

    This is a critical feature for our business. If you would just allow the ability to reference that field, I could take it from there.


    Thanks,

    Amy McCann

    · Share on Facebook Share on Twitter

Categories

Is there any data in the source file?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}]},{"discussionID":109402,"type":"question","name":"Reminder workflow not working","excerpt":"I have a workflow specific to a rush order. When rush order is stared on the form, the workflow triggers to run hourly. Then there is a condition \"If rush order is \"checked\" and status is \"submitted\" instead of accepted or declined it sends a reminder to the approver. The alert works once but doesnt continue to send…","snippet":"I have a workflow specific to a rush order. When rush order is stared on the form, the workflow triggers to run hourly. Then there is a condition \"If rush order is \"checked\" and…","categoryID":321,"dateInserted":"2023-08-24T15:07:16+00:00","dateUpdated":null,"dateLastComment":"2023-08-24T15:30:04+00:00","insertUserID":162330,"insertUser":{"userID":162330,"name":"d.hickey","title":"David Hickey","url":"https:\/\/community.smartsheet.com\/profile\/d.hickey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-24T18:10:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-24T20:19:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":25,"score":null,"hot":3385782440,"url":"https:\/\/community.smartsheet.com\/discussion\/109402\/reminder-workflow-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109402\/reminder-workflow-not-working","format":"Rich","lastPost":{"discussionID":109402,"commentID":392368,"name":"Re: Reminder workflow not working","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392368#Comment_392368","dateInserted":"2023-08-24T15:30:04+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-24T20:19:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-24T15:45:06+00:00","dateAnswered":"2023-08-24T15:30:04+00:00","acceptedAnswers":[{"commentID":392368,"body":"

Ok. So the trigger is the issue. You have it set to only grab rows that have been added or changed within the past hour.<\/p>


<\/p>

My suggestion (tedious but effective) is to adjust the trigger to be daily (date based with custom selection of every 1 day) and run at a specific hour with the same conditions.<\/p>


<\/p>

Duplicate the workflow and adjust the hour to be the next hour. Duplicate again and adjust the hour. So on and so forth for each hour that you want to run the workflow on (this allows you to restrict it to only during business hours so someone isn't getting a ton of emails all about the same thing while they are sleeping).<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":109379,"type":"question","name":"Manage Workflows and Saved Workflows","excerpt":"Good day all - I am still new on this platform can you please assist me in this question I have for Manage Workflows and Saved Workflows - I am having this occurring issue with an error I get when I try to save my workflow automation. All my conditions runs successfully but when I change action to alert someone. The send…","snippet":"Good day all - I am still new on this platform can you please assist me in this question I have for Manage Workflows and Saved Workflows - I am having this occurring issue with an…","categoryID":321,"dateInserted":"2023-08-24T07:56:33+00:00","dateUpdated":null,"dateLastComment":"2023-08-24T14:08:36+00:00","insertUserID":165593,"insertUser":{"userID":165593,"name":"Riana","title":"R","url":"https:\/\/community.smartsheet.com\/profile\/Riana","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9FLSSWC8RCEG\/nBVJ1OR1G1MKI.jpg","dateLastActive":"2023-08-24T13:43:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":80301,"lastUser":{"userID":80301,"name":"Debbie Sawyer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Debbie%20Sawyer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-02\/6f\/d1\/n6fd11e91b71000f2b152e84c8f072631.jpg","dateLastActive":"2023-08-24T14:07:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":35,"score":null,"hot":3385753509,"url":"https:\/\/community.smartsheet.com\/discussion\/109379\/manage-workflows-and-saved-workflows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109379\/manage-workflows-and-saved-workflows","format":"Rich","lastPost":{"discussionID":109379,"commentID":392316,"name":"Re: Manage Workflows and Saved Workflows","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392316#Comment_392316","dateInserted":"2023-08-24T14:08:36+00:00","insertUserID":80301,"insertUser":{"userID":80301,"name":"Debbie Sawyer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Debbie%20Sawyer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-02\/6f\/d1\/n6fd11e91b71000f2b152e84c8f072631.jpg","dateLastActive":"2023-08-24T14:07:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-24T13:26:28+00:00","dateAnswered":"2023-08-24T12:46:28+00:00","acceptedAnswers":[{"commentID":392292,"body":"

Is your Site Name column called Site Name or Site Name:<\/p>"},{"commentID":392309,"body":"

Hi Debbie<\/p>

You are right on this one. The problem was my Site Name: it was as Site only on my sheet. I now resolved my issue. My workflow is saving successfully now. I Thank you so very much for your assistance. Please ignore the mail trail that I send you.<\/p>

You must have a wonderful day. I appreciate your assistance.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":4984,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics

  • Error When Importing Google Sheet

    I was able to import this sheet successfully once as a test. Now when I try to import I get the attached error that states that the Excel file is invalid, but I didn't select to import and excel file! Any help would be appreciated!

  • Reminder workflow not working

    I have a workflow specific to a rush order. When rush order is stared on the form, the workflow triggers to run hourly. Then there is a condition "If rush order is "checked" and status is "submitted" instead of accepted or declined it sends a reminder to the approver. The alert works once but doesnt continue to send…

  • Manage Workflows and Saved Workflows

    Good day all - I am still new on this platform can you please assist me in this question I have for Manage Workflows and Saved Workflows - I am having this occurring issue with an error I get when I try to save my workflow automation. All my conditions runs successfully but when I change action to alert someone. The send…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video