Project Management

Discussion List

  • 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
    26 2
    Answered - Pending Review 26 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
    13 7
    Answered ✓ 13 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
    58 2
    Answered - Pending Review 58 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
    14 1
    Answered - Pending Review 14 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
    59 1
    Answered - Pending Review 59 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Task duration as a function of the task Allocated %
    In Using Smartsheet
    Hello!, Can task duration be calculated as a function of the allocation percentage? If one person is allocated 100% for one week then being allocated at 50% the task should take two weeks, etc. Another case may also be useful. If one perso…
    Answered - Pending Review
    88 4
    Answered - Pending Review 88 views 4 comments Most recent by Sylvain Martel Using Smartsheet
  • Sequential Number
    In Formulas and Functions
    I am creating a Project Numbering system in a sheet that are generated based on selected criteria's. The last 3 digits would need to be sequential numbers "000" Auto-numbering will not work for this application as the criteria's …
    Answered - Pending Review
    171 14
    Answered - Pending Review 171 views 14 comments Most recent by Paul Newcome Formulas and Functions
  • Change cell color based on date from another sheet
    In Formulas and Functions
    Hello! I'm working on a project overview sheet for many overlapping timelines. I'd like to make it so that if any of the projects have the date that the column is named that cell highlights or changes color. So, for example, if project 1 t…
    Answered - Pending Review
    58 2
    Answered - Pending Review 58 views 2 comments Most recent by Nicolette Marinos Formulas and Functions
  • How to List Parents By Common Child
    In Formulas and Functions
    I am working on a project book of work and currently have a list of resources listed by project: Project 1: Rich John Angela Carly Ted Project 2: Tim Jeff Rich Ted Project 3: Sam Tim Ted I am looking to create another sheet that will auto…
    Answered - Pending Review
    52 6
    Answered - Pending Review 52 views 6 comments Most recent by Genevieve P. Formulas and Functions
  • Link an individual task?
    In Using Smartsheet
    I've tried searching for this and haven't found info - I apologize if it's out there! Is it possible to send a link to an individual task? Sometimes, that's helpful. Since I group all relevant info into individual tasks on the card (e.g., …
    Answered - Pending Review
    36 1
    Answered - Pending Review 36 views 1 comment Most recent by Andrée Starå Using Smartsheet