Project Management

Discussion List

  • Hourly view on Gantt View
    In Using Smartsheet
    Hi 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…
    Answered - Pending Review
    34 1
    Answered - Pending Review 34 views 1 comment Most recent by Sean Morgan Using Smartsheet
  • Setting up a Project Portfolio- next steps
    In Using Smartsheet
    Hi 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…
    Answered - Pending Review
    27 1
    Answered - Pending Review 27 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Flag is others are flagged
    In Formulas and Functions
    I 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 …
    Accepted
    19 3
    Accepted Answer 19 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Recommended format
    In Using Smartsheet
    Hi 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…
    Answered - Pending Review
    17 5
    Answered - Pending Review 17 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • Color code Gantt bar
    In Using Smartsheet
    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
    Answered - Pending Review
    32 3
    Answered - Pending Review 32 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Is there a way to create a list out of joined string in a cell?
    In Formulas and Functions
    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]........|........Par…
    Answered - Pending Review
    17 2
    Answered - Pending Review 17 views 2 comments Most recent by Jorge Villarreal Formulas and Functions
  • Project Settings from Report Glitch
    In Using Smartsheet
    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 proje…
    Accepted
    16 7
    Accepted Answer 16 views 7 comments Most recent by Nik Fuentes Using Smartsheet
  • What is the best way to connect "predecessors" in SmartSheets to Jira?
    In Apps, Integrations, and Add Ons
    My 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 2
    Answered - Pending Review 40 views 2 comments Most recent by E. Robert Shanfeld Apps, Integrations, and Add Ons
  • How to show names of issue submitters on dashboard?
    In Using Smartsheet
    I 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…
    Answered - Pending Review
    15 1
    Answered - Pending Review 15 views 1 comment Most recent by Jeff Reisman Using Smartsheet
  • Using Smartsheet Template "Project Issues Log"
    In Formulas and Functions
    The 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 1
    Answered - Pending Review 22 views 1 comment Most recent by Andrée Starå Formulas and Functions