-
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…
-
What does community mean to you?
I’ve been wondering about this lately. This morning I looked within and asked myself what community means to me. I came up with one word: Belonging Even for someone like me, an ambivert who introverts to extrovert understanding and appreciates the importance of community and the sense of belonging it creates. This is why…
-
Change the "from" email address on automated emails
I am the owner but I have sheets built for a user and any time an automation sends an email the recipient sees the following: FIRSTNAME LASTNAME via Smartsheet <automation@app.smartsheet.com> I do not want my name on these automation emails, is there a way to change it to someone (workspace collaborators / users) via…
-
WorkApp Comment: No Red dots showing for new added comments
We built a Workapp portal for our clients with edit access on the reports only (no sheet level access was given to any of our clients for security purposes). Now, I'd like to know why there's no red dots showing for new added comments when they're working at a report level housed inside the WorkApp. It's not helping our…
-
Ability to Count Comments at the Row and Sheet levels
As I'm sure many others are, we are using Smartsheet for project intakes. My executive team wants to be able to count the number of comments per row, as it will show how many times the operations team had to contact sales or other departments for additional information or reminders regarding a particular request. Each row…
-
Automated way to move "Comments" (Conversations in Smartsheet) from column to Conversations
Hi, I have a team maintaining an Action Tracker. All are relatively new to Smartsheet from Excel and most are at a higher pay grade than me. As such, they asked for a "Comments" column in the Action Item grid to track DAILY actions and updates. As you can imagine the row sizes are quickly becoming unmanageable. Is there…
-
Filter report to only items where comments mention specific text
I'm looking to create a report that will show me only the records where I am mentioned/tagged in the comments. This is not a comments column, we are using the standard 'comments' functionality. Would even be sufficient to just filter on any rows where the comments are like '%SomeText%'. Seems fairly similar to this post…
-
Tag for Sellers or Service Providers
can there be a requirement for community participants advertising for the services they sell to have a user tag or disclaimer? In addition it would be very beneficial to restrict advertising in the feature request forums, that is just not the place.