-
Color code Gantt bar
Hi there! I'm looking to code the color of Gantt bars based on the value of a different colum, called "Location". Is there a way to do this? Thank you, Esperanza
-
Project Management Office Template - Silly Question
Hi Community!! I'm working my way thru setting up a project portfolio using the Project Management Office template which is amazing! I have sort of a silly question......the Intake Form and Project Intake Sheet request something called a "Category". How should I think about categorizing the projects in the portfolio? How…
-
2 or more projects sheet dependency
HI, I am using Smartsheet and I am involve in 3 projects and all are main and lead roles. I made 3 separate sheets for each project but I realize each projects affect the other projects and then sometimes the predecessor is in another sheet. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> For example: Project A sheet Task # 25 on…
-
Project Phases of Development
Hello! I am trying to find a way to show the development stage of a project so it can be rolled into a report. Basically if all of the tasks in a section are complete, then the development stage would be the name of the next header task. For example (see image), if "Project Planning," "Drafting," and "Developing" are all…
-
Data storage EU
Hello! I'm afraid my question is not a new one, but I'm not giving up hope that Smartsheet is interested in expanding into Europe. Since I realized, that EU-GDPR seems to be accepted, the IT-data-security-departments at my Clients in Germany are still focused on where Smartsheet stores the data. Tha is top level of…
-
How to create a master schedule sheet in project prog schedule mode by linking other schedule sheets
Hello, first of all sorry for my English, I'm doing a translation from French. I work in the construction industry and we have big construction projects. Each major construction project includes several complex tasks. Each of these tasks is a project in itself and it has its own schedule. The goal is to bring together all…
-
Is there a way to create a list out of joined string in a cell?
I have Sheet A, were I have a column with Task Description that has parents. I created another column where I put the parents corresponding to the child. Example: Parent ID .........|........Task Description [blankcell]........|........Parent 1 [Parent 1].........|............Task 1 [Parent 1].........|............Task 2…
-
Outlook Integration not installing
Inside of Outlook, I have clicked "Store Add-ins", found "Smartsheet for Outlook" and clicked that. I then clicked the blue "Add" button. This then briefly changes to "Adding..." then to "Added". When I go into my Outlook email list, there is no Smartsheet icon. When I go back into "Store Add-ins" and find "Smartsheet for…
-
Does the Project Plan have to be named "Project Plan"
Hi If I have multiple projects, is separate folders, does each project plan sheet have to have the same name, i.e. "Project Plan" in order for links to remain when a new project, project folder is added?
-
Project Settings from Report Glitch
Curious if anyone has issues using the "Project Settings" button (small gear icon in the top right under the share button). We thought we can adjust the project settings for the Gantt view on a report (or does it adjust the project settings for the whole sheet)? Either way, when we click the icon nothing happens. After the…