Please add functionality to toggle Name or Commenter to off when a column is set to Latest Comment. For example:
"Park Approved 1/31" instead of "Mike Stone - Park Approved 1/31"
Sign in to see the current vote count, add your own vote, or leave a comment.
It would be great to have a toggle option to make the Name of the person who added the more recent column in an auto-generated "Latest Comment" row not show.
It would be helpful to see just the comment in the Latest Column. If someone wants to know how added the comment, they would be able to see it when they open up the Conversation panel. The current format makes it hard to see the information quickly.
This is also a feature that I would like... In the meantime, I use a column formula to hide the user's name:
=IF(LEN([Latest Comment]@row) > 0, RIGHT([Latest Comment]@row, LEN([Latest Comment]@row) - FIND(" - ", [Latest Comment]@row) - 2), "")
This basically determines the position of the " - " string and trims this section from the comment.
Hope this helps!
@tominwood -
This is amazing. Thanks for sharing. I cut pasted the formula into my sheet and I get an #UNARSEABLE Error. Should it work if I cut and paste into my sheet or do I need adjust the syntax? Any guidance on how to fix the formula?
You need to change the "Latest Comment" text to match the column heading for your Latest Comment column. So if this is called something else you'll get an error (until you update the formula) :)
@tominwood - Thanks for the correction! I have it working.
Update: I'm able to use the formula but I now have 2 columns. 1 column is the Notes column and the 2nd column is the Notes column with the formula and it works.
I tried using the formula in the notes column and it threw a #CIRCULAR REFERENCE error. Is there away to embed your formula in the notes column and eliminate the helper column? If not then I can it work with a helper column.
No, it relies on having that column unfortunately. So you can lock and hide the system-controlled Latest Comment column and just show the new one instead :)
Thanks for confirming I set the columns up correctly. I'd rather have the hidden helper column and less noise in our comments field. Thanks for sharing the work around with me.
The author's name of the latest comment in the latest comment field always appears before the actual comment. This can take up critical space in my sheets, making the latest comment column wider than it needs to be (Ex: Jane Doelonglastname - drawings completed on Thursday). It is useful to see who left the latest comment, but its not more important than seeing the comment that was made. I would like to have an option to toggle on or off, the author's name appearing before the comment in the edit column properties. Even if it was toggled off, and I want to know who make the comment, I can simply open the conversations window. Just would be a nice feature to tidy up sheets. What do you think?
@tominwood and @mistone THANK YOU!!! My name is so long and I'm so happy to not see it all over my sheet. :)
@tominwood Thank you so much man...
Now it's much more powerful to use Last Comment feature.
Salute !!
I would like to have the on/off toggle feature for the names in the Latest Comment column as well. When the column is used for a report/dashboard, it is unnecessary information.
@tominwood Thank you SO much! This was such a great workaround! Just create a second column, make this formula a column formula in the helper column, and voila!
Thanks! Works like a charm!
I noticed this the other day and tested Ctrl + M – it does not work. I submit ticket to Smartsheet support – they told me that’s expected behavior because it’s not currently available even though it still shows as keyboard shortcut in the menu🙄 and told me to submit new product idea. Please add this keyboard shortcut to…
Summary of Issue All team members work a standard 7.5‑hour day, but only a portion of that day is allocated for project work (e.g., 25%, 50%, etc.). In Resource Management, however, the system currently interprets allocations as a percentage of the full 7.5 hours, instead of the project‑eligible portion of a person’s day.…
Dashboard widgets are currently mostly static. I can display counts and charts, but I cannot click into a specific part of a widget to drill into the underlying records. It would be a big usability improvement if widgets supported interactive drill-down. For example: Click a bar segment (or stacked segment) to open the…
