Project Management
Discussion List
-
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 26 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 58 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 59 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Task duration as a function of the task Allocated %In Using SmartsheetHello!, 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 views 4 comments 0 points Most recent by Sylvain Martel Using Smartsheet
-
Sequential NumberIn Formulas and FunctionsI 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 views 14 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Change cell color based on date from another sheetIn Formulas and FunctionsHello! 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 views 2 comments 0 points Most recent by Nicolette Marinos Formulas and Functions
-
How to List Parents By Common ChildIn Formulas and FunctionsI 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 views 6 comments 0 points Most recent by Genevieve P. Formulas and Functions
-
Link an individual task?In Using SmartsheetI'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., …
