-
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…
-
Reference Auto ID column and other fields in automated Comment emails
Context: When entering comments, the automated email that gets sent when @someone is used references the row number of the comment. Row numbers change as items are added and removed, which can lead to confusion when only referencing the row number. Using the Auto-Generate Row ID functionality provides a static identifier…
-
Disable Comments for a single Sheet?
Is it possible to disable the use of comments on a single sheet? Or is there a way to get an alert to someone, perhaps sheet owner/admins or a special group when there is a comment added?
-
Merged: Copy Attachment and/or Comments between sheets
This discussion has been merged.
-
Can I comment and tag a SmartSheet Group in the comments/email?
I have found older posts that this is not an option through SS although I have been told it is by someone at SmartSheet. I was told that I could @groupname to ensure all parties (or a subset of those to whom the sheet is shared via setting up different groups) are sent comments vs. having to go into SS and review for…
-
Error message: All unsubmitted comments will be discarded
Hi All -- when my colleague is trying to update his project plan with comments in the Comments column, his comments keep disappearing when he re-visits the project plan. He has Admin access. I can leave comments and mine will stay, and all of my 15 other project managers can. But he can't. It's bizarre. Help?
-
Block Ability To Add Comments
I have a published sheet, which needs to remain in a published status as we need to allow non-licensed users to change a date in the Sheet Summary. However, I want to block their ability to add comments to the sheet. Is this possible? I've figured out how to hide the comments column on the left side, but they're still…
-
Latest Comment Copies Wrong Time
I have two columns that I have users enter data, formula combines it with the current modified date and time, then automations copy those rows to another sheet, so the history is preserved with the time. I then use the JOIN/COLLECT trick in new columns on the original sheet to show a log of that data change over time. One…
-
How can I change the WBS phase number for my WBS by phase?
Hello, I am trying to figure out how to change the WBS phase number for specific tasks in my project. For some reason a group of about 15 tasks is assigned to phase 1 in my WBS, but they should be phase 10. The WBS number is showing 10.1, 10.2, 10.3, 10.4 and so on, but the phases for these are locked in. How can I assign…
-
Hide Attachments and Comments on Reports within WorksApps
We have some internal sensitive data saved as attachments that we do not want our clients to see. I have hidden the Attachments and Comments Column on the Reports and saved them as View Only within WorkApps. However, the users can still view the attachment even though I have hidden the Attachment column, by right clicking…