Smartsheet Basics

Archives for June 2018

Row sorting
I use smartsheet to keep track of project stages, I have 5 stages of the lifecycle all sorted by a different color. Is there a way to organize the rows so when that stage is reached, the row automatically moves to the bottom of the next section?
ERROR: Java.Lang
I receive this error when trying to install Smartsheet in Microsoft Teams. Any ideas what the problem is? An unexpected error has occurred. Try again and contact support@smartsheet.com if the problem continues. Cause: java.lang.NegativeArraySizeException.
Licensed User Reports
Does anyone know of an easy way to see a report of licensed users and the last time they: Created a Smartsheet Accessed a Smartsheet I'm trying to clean up our licensed users because I don't think the licenses are distributed properly. Contributors don't need to be licensed users and I need to free up some licenses. Thanks…
How to Create A Template Set
I've created several project management files (sheets, reports, dashboards). How can I save these as a template set (package) for others in my organization to use/download? Or is it save as a workspace??
Resource View by Project
Hi I wonder if anyone might be able to shed some light on an issue I'm experiencing. I'm a new Smartsheet user so I could well be doing something wrong or expecting Smartsheet to work in a way that it doesn't. I'll set out the issue below and if anyone can explain what I'm doing wrong, or if there is a different way to do…
Can you download with the changes highlighted?
HI, New user to Smartsheet and I wonder if it's possible to download an excel copy of a document with highlighted changes? I know how to use the highlight feature, but it would be really useful to be able to have these on the export copy. Is it possible? Thank you!
Copy&Paste with relative predecessors
Hi, I have a schedule (created from Project template (aka Gantt chart)) where I have a section which is repeating several times in the schedule. Inside of a section I have dependencies linked using Predecessor field which do not point outside of the section itself. You can imagine this as an agile sprint schedule where…
Transferring everything within a workplace to a new Owner
Hello, As you can probably see from the title I would like to transfer everything within a workplace to a new owner. This includes templates, sheets, reports and dashboards, how would one go about doing this? Kind regards Anton
Today is not shown in report timeline of a dashboard
Hi, I created a project timeline in SmartSheet. The today's date is indicated with a dotted line in Gantt view as well as a report created based on the project sheet. However, today's date was not shown when I included the report in a dashboard. Can I do some setup so that today's date is indicated when the report widget…
Overall Project Status
Hey Everyone, I'm trying to create an overall project status similar to the one displayed in the "Maximize Your Smartsheet Experience" webinar. https://www.smartsheet.com/videos/maximize-your-smartsheet-experience?frame=0&nav=1 Around timestamp 4:50, a task status is updated from red to green via an update request. Once…

Trending in Smartsheet Basics

Conditional formatting - OR condition?
I need to use conditional formatting to specify an OR condition on multiple columns. I only see the AND condition option. Without an OR condition, I have to create multiple conditional formatting rules. Is there any way to get an OR option for the conditional formatting? Why would there be just an AND option and not an OR…
Update Request not sending to contact in column
I have an update request Scheduled to send to contact in a column. When I veiw the pending update request it is telling me that it was sent to myself instead of the contact in the column?? Thoughts?
Group by Priority - Not in Order
When I try to group by the priority (high, medium, low) it will not allow me to sort them in high medium and low, it is sorting them alphabetically. Has anyone found a way to optimize this so that I can group my projects by priority and see them in high - medium - low order?

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

Watch video

Smartsheet Basics

Discussion List