Project Management
Discussion List
-
Hourly view on Gantt ViewIn Using SmartsheetHi there, We have a project with vehicles moving across multiple locations and would like to keep tract of their activity by the hour. We don't so much need to track their GPS location as much as, Car # 1 is in Town A, and then needs to g…
-
Setting up a Project Portfolio- next stepsIn Using SmartsheetHi all, I am new to the community and pretty new to Smart Sheets. I have been tasked with creating a project portfolio with a hopper of projects ready to start when resources become available. I have built the project portfolio linked to…
-
Flag is others are flaggedIn Formulas and FunctionsI have an "At Risk" column and I want one row to flag if any in a set range of others are flagged. For example, on a project template, I have a "Planning Milestone"; I want the milestone to flag if any rows within the …
-
Recommended formatIn Using SmartsheetHi there, I'm looking to track daily activities of field staff. This involves broadly tracking daily tasks but perhaps more importantly location of staff in the field (who is where and when) and the work vehicle they are using (we have ab…
-
Color code Gantt barIn Using SmartsheetHi 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
-
Is there a way to create a list out of joined string in a cell?In Formulas and FunctionsI 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]........|........Par…Answered - Pending Review 17 views 2 comments 0 points Most recent by Jorge Villarreal Formulas and Functions
-
Project Settings from Report GlitchIn Using SmartsheetCurious 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 proje…
-
What is the best way to connect "predecessors" in SmartSheets to Jira?In Apps, Integrations, and Add OnsMy dev team uses Jira, while the project team wants to use SmartSheets for Gannt charts, dashboards, etc. If we create tasks in Smartsheets through templates, how can we carry over "blocked tasks". In SmartSheets, we refer to it …Answered - Pending Review 40 views 2 comments 0 points Most recent by E. Robert Shanfeld Apps, Integrations, and Add Ons
-
How to show names of issue submitters on dashboard?In Using SmartsheetI am tracking issues logged, and want to show the names of the ppl logging issues on a dashboard. I only want to show the name once, even if they've submitted multiple issues. Ideally this would appear as a list, with the name in one colum…
-
Using Smartsheet Template "Project Issues Log"In Formulas and FunctionsThe Product Issues Log is a template from the Creating Risk and Issues log training. This template is supposed to automatically move an item from the Open area of the sheet to the lower closed area when it is closed. I know there is someth…Answered - Pending Review 22 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
