Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Archived 2015 Posts
Archives for July 2015
Discussion List
Is there a way to apply conditional formatting or grouping to reports?
Looking for a way to utilize the reports functionality. It would really help to have conditional formatting capability as well as grouping functions.
User Management and Contact List type
Good morning, If I am understanding this correctly, the User Management is what the Contact List type draws from to populate names. Is there a way to create different groups within the User Management area? For instance, I'd like to have two separate lists so that I can have two different Contact List types in my sheet.…
If / and formula
I am having a slow day, brain wise today. I need to have a formula for a RYG column, that looks at two check box columns. First checkbox will change the RYG ball from Red when not checked to Yellow when checked. Then i have a second check box column for another department to change the SAME RYG ball column to GREEN when…
Priority rows
How do I insert a priority row and lock it. thanks Kurt
Task text disappearing when highlighted after a few seconds
Does anyone else have the annoying problem of a task text disappearing if you leave your cursor on the line item for 10 seconds?
Assigned To/ Status chart
Hi Everyone, I am trying to create a chart using the app in Smartsheet labs which displays the number of projects per handler and split into the status. I can create a Bar Chart showing the count of projects per handler but when I try and make a similar chart which splits the count by status it says that I can't. The issue…
Can I 'hide' lines from certain people?
Hi, I have project plans that are shared with both internal and external people - is there a way to 'hide' some line items from external/nomiated people? Thanks!
Permission to view a report in one Workspace that points to a sheet in another Workspace
I would like to create a report in a Workspace that is view only to a group in that Workspace, and have this report pulled from a sheet in another Workspace that this Group would not be allowed to view. This does not seem to work, as the Group permissions don't allow this report to be run since this group is not allowed to…
Status Symbols (traffic lights)
Hi - Can we have set with 5 traffic lights. There is currently four and we use them to represent on-track (green), at risk (orange), overdue (red) and complete (blue). We feel we are missing one to indicate 'not started'. You already have a grey traffic light but it is in another set of four and it would be very helpful if…
Formula's for [Start Date] column when dependencies are enabled
Hi, I am currently trying out Smartsheet in order to decide if we will be able to use this at our company or not. I'm using the construction timeline with gant chart template. I would like to add project management fee payment dates as milestones. Payment #1 linked to start of the project -> OK, no problem Payment #3…