-
Guidance on using Smartsheet to support PMO processes
I am about to move my PMO process to Smartsheet and am trying to figure out how best to structure this. Currently, we have a standard set of tools that we issue to a project manager when the project starts, this includes Scope, Business Requirements, Test Plans, Meeting Minutes, Issue/Decision/Risk Log, Project Plan etc..…
-
Hiding Formulas
Hi, I am designing solutions for several clients on Smartsheet. Is there a way to hide the formula so it doesn't display when you "mouse over" it? I don't want the clients to see "my magic" - very easy for them to copy it and do it themselves... Thx Werner
-
New update has broken reports, cell drop down lists are gone
As of this morning, dropdown lists no longer work in any of our reports, only the main sheet. This is a major problem...any ideas what's going on? Logged out and logged back in several times, but to no avail.
-
Freeze date
Is there a way to freeze a date =today() if a date field is controlled by a check box field once 24 hours passes? If check box checked = today. Excel suggests using vba. I am not certain if there is a way in SS to do this type of function without the date changing. Thoughts...suggestions?
-
Create a resource view
I have a number of sheets with a large number of people on a team all doing part of the work. The Report feature is good at showing the tasks on a gant chart across the business but it presents it as one line per task which means that there are possibly 15 lines for one person. Thats a bit difficult to manage. The calendar…
-
Assessments
Can Smartsheets be used to provide assessments of businesses? If so, are there any recommended templates that could be used to accomplish this mission?
-
[Solved] App crashes in android restricted profile
We've been succesfully using the Android app for about a year. Recently our tablets using restricted user profiles have begun crashing the app upon launch. The admin profile works fine, just the restricted profiles fail. Our current app version is 3.2.0.341 Android version 4.4.2 What I've tried: Cache Purge>reboot Cache…
-
making sub lanes in kanban
Hi everyone. I particularly like the Kanabvan sheet as we can visually see the progress of a project as it moves from one are to the next. However, im looking to see if its possible to create "sub lanes" within lanes to creat a flow path that starts top and ends in bottom and then moves into another lane. Each lane is a…
-
Tracking a date change
I am new to Smartsheet in a company with limited knowledge about the features. We use a combination of sheets and a web form for 'ad-hoc' requests that are managed in a queue. In the queue, there is a "Due Date" column. This date can change over time and the manager for the area would love to be able to track that change…
-
Gantt colour bar and % complete colour
Does anyone know how to change the % complete colour in a Gantt chart? The colour of the colour bar and the % complete are too close and I would like a bit of contrast. ie blue colour bar and yellow % complete.
