-
Nesting Formulas
I need some help with nesting formulas for the following screenshot: What I'm trying to accomplish is an automatic change in the "Status" Column based on the following criterias: 1) If "%Complete" >= 1% and "%Complete" <= 99% and "At Risk" = 0 then "Status" = In Progress 2) If "%Complete" >= 1% and "%Complete" <= 99% and…
-
Change Management Solution
Does anyone use Smartsheet for Change Management scheduling? We are in the process of creating a change management committee and are currently housing our Change requests in Lotus Notes Database.... Which is less than desirable. Trying to see how we could use Smartsheet to accomplish this... Anyone currently doing this or…
-
Smartsheet Navigation
I have always found navigating between sheets a bit cumbersome. I have several workspaces and lots of sheets. Currently the fastest way to find a sheet is to do a search. The favourites is a neat idea but I usually gave to navigate out of my current sheet to the home tab and then again to the favourites tab. What would be…
-
Unable to highlight an entire row
I am unable to highlight a entire row. It appears the box that was lasted edited will not highlight. Also, if I edit a highlighted row the box will turn white. I attempted to use the paint brush to get around this issue and it works sometimes. Kindly let me know if you have any tips pr tricks
-
Need the ability to filter reports based on project status
Here is what I need. I have about 50 projects within a workgroup that I am trying to manage. I have a report of tasks that are due within the next 5 days. Took some cluncky work to differentiate tasks vs summary tasks, but it was easy enough to do. Next issue / challenge. When a project stalls for some reason or another, I…
-
Project Initiation form in SS?
Everyone, I would like to use SS to provide a central point for business units to entering new project requests. Wondering if anybody has used SS for that purpose and with what results. Is SS right fit for that? Maybe it's not. Thanjs
-
Communicating "definitions or conventions" SmartSheet
All, I am new to SS. As I post a roadmap in SS I would like to communicate "definitions" in help text or somehow to the viewers of the SS. For example, I will have color flags to provide project status in terms of scope, schedule, cost, etc. How can I help the viewer understand my definitions for green, yellow, red?…
-
SmartSheet Setup Consultant
I am unable to locate this information. I see that there are multiple opportunities to train online or at a meeting, but do you know if they have techs that will come to a location and set up projects/training based on needs? Thank you.
-
Best Practice for Backing Up
My project management team joined Smartsheet about 6 months ago and have created quite the plethora of sheets. All of them are in use as we are managing a very large project, so I do not want to delete any (and as we have so many paid users, we are far from our sheet limit) and they are all dynamic/active sheets. However,…
-
Send Row Feature - Remove Log In button?
I'd like to be able to send rows to people that are not users in our SmartSheet account, but fill out a form that populates rows in our sheet. Is there a way to remove the Log In button in the header of the "Quick Update" email that goes out when you "send row"? I like the logo that is left justified in the header, but…
