Project Management
Discussion List
-
Task duration as a function of the number of resourcesIn Using SmartsheetHello! Can task duration be calculated as a function of the number of resources? If one person takes three weeks then allocating three people should complete the task in one week, etc. This should be easy but I can't find this capability. …Answered - Pending Review 32 views 2 comments 0 points Most recent by Michael Wilson Using Smartsheet
-
Is there a way to update source sheets for multiple reports?In Using SmartsheetWe created about 30 reports. Each of them is taking the data from multiple sheets (each sheet is a project that our team is working on.). When we add a new sheet (new project), we have to go through each report one at a time and add the ne…
-
Options to show multiple project plan sheets into one viewIn Using SmartsheetI currently have a project where I have project plan sheet for each country. I'd rather keep them separate than combining into a single sheet, however I'd like to show the combined details in Gnatt view and checking for date overlaps. Ha…
-
Template recommendations for tracking product design approvals and status from design to production?In Using SmartsheetSo I've been looking at Smartsheet as a solution to a project tracking problem, but I'm having a hard time finding a template for the purposes I'm intending it for. If this needs to be created from scratch, I'd love to be pointed in the di…
-
Request for advice on best way to structure sheet column fields / data for reportingIn Using SmartsheetPlease give me your input on the best way to structure my sheet data to achieve the reporting/summary options desired. The current data is being migrated from an Excel workbook with ~20-30 column fields per row which makes it difficult to …
-
If Children Contain then display cell on that row in Parent CellIn Formulas and FunctionsHave children() that vary in range, children rows can vary from 1 to ~30. For each child that contains "Action" in column [Issue Category] display the cell Notes contents into parent row Notes cell. Currently using static for…
-
Project Plan - Excluding rows from the overall completion percentage calculationsIn Formulas and FunctionsI am creating a project plan that will be used for Lifecycle maintenance programmes. Each project plan will consist of up to 8 different work packages which will have their own task lines in. (See attached pic) This basic format will be th…Answered - Pending Review 108 views 2 comments 0 points Most recent by JeremiahHorstick Formulas and Functions
-
Automated Copy / Move rows between sheets - just copy some columnsIn Using SmartsheetDear all, I'm a project manager and recently started using Smartsheet. I'm trying to configure an intake-prioritization and approval process for all the projects requested by our users. I have my main sheet called it : Project Requested …
-
Convert form response in to standalone project?In Using SmartsheetHi, I created a Smartsheet form to intake requests for support from my team. I'm not aware of an easy way to then create a project based off of the form response without having the Control Center add-on. Ideally I would like to set up a s…
-
How do I automate the creation of a project schedule from a form submission?In Formulas and FunctionsHoping someone might be able to help me figure out this workflow: Form is submitted requesting a new project with the following information: name of project, requested go live date, assigned project manager This form submission triggers a …
