-
Is there a way to capture the latest comment on a sheet?
In a project schedule sheet, where comments are made on rows/tasks, I want to grab the comment that was made last on that project sheet to use in a summary report. I know you can view all the sheet comments, but I only want to capture the last comment made on the sheet. Goal is that the summary sheet will always have that…
-
How to attach notes to a line item
Hi, I need to attach notes to my line items. Setting a column as a Note Field is not practical, as I have too much informaiton than can fit on a short line. Using Comments is not practical, as I need to be able to easily access and edit the notes, not scroll thru a list of Comments. How to achieve this in Smartsheet? Thank…
-
Report on Last Comment date?
I'm seeing that the System Modified field is NOT updated after entering a new comment on a row. Is there a way to report on the Last Comment Date? I am trying to identify a way to create a report on my sheet that shows Last Update dates, and Comments are being utilized to provide a status update, or entry of the last…
-
How can we link a reply in Slack back to SmartSheet without clicking a link back to SmartSheet?
We already linked the SmartSheet with Slack where we received a notification of a comment in Slack, but we noticed that it is only when we use @ as mentioning from SmartSheet comment. Is this true? We also cannot receive a reply back in Slack captured in SmartSheet, unless we click the link in Slack to open SmartSheet to…
-
Dynamic View - Visibility of Attachments & Comments
Dynamic View does not seem as user-friendly as in regular view/ sheet mode. Dynamic view - The attachments including photos are not viewable straight away as a small preview as they are in sheet view. It seems you need to download the image every time you need to view it. It also means when you view multiple photos, you…
-
Seeking Assistance with Smartsheet for Task Management
Hi all, I’m very new to Smartsheet and am keen to explore its features with the goal of eventually rolling it out in my work area. I have an enterprise license assigned through the Government. In our area—Media and Corporate Communications—we receive many tasks through Microsoft Outlook. These often include requests for…
-
Export with ALL comments
I can't seem to find a way to include all comments in an export to Excel. The export only shows the latest comment or set of comments. Pulling a row report doesn't give an option to include comments. And the Conversations view doesn't give a way to export all the comments from that angle, either. Any ideas to gather all…
-
Reactions to Comments
As a company we have many people that look at our Smart Sheet so we can all stay up to date on our latest projects. That being said we rely heavily on the comment section to keep everyone on the same page. It would be nice if there was a way to "like" a comment, or once someone views the comment you can click it and it…
-
collecting all comments in one cell?
Hi there, I am trying to collect all comments in to one cell following these formulas: =JOIN(COLLECT({Comments}, {Row ID},[RowID]@row)) =JOIN(COLLECT({Comment Only}, {Row ID}, [Row ID]@row), CHAR(10)) Example explaining it: a way to collect all comments in one cell - Smartsheet.com however, it keeps giving me #UNPARSEABLE…
-
Comments to appear in email notification for update request
We have set up an update request automation to include comments. However, when the email comes through, it does not show the comments and the only way to view them is to open the request. It would be nice to see the comments in the emailed notification prior to needing to open the request.
