Project Management

Discussion List

  • 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
    89 14
    Answered - Pending Review 89 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
    49 2
    Answered - Pending Review 49 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
    36 6
    Answered - Pending Review 36 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
    29 1
    Answered - Pending Review 29 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Baselines - Variation Field in Business Days?
    In Using Smartsheet
    Really happy to see this baseline feature in Smartsheet and have been using it effectively. There is one item that doesn't quite seem to make sense with other smartsheet behavior for me. The Variance shown is in absolute days between two d…
    25 3
    Accepted Answer 25 views 3 comments Most recent by Genevieve P. Using Smartsheet
  • Introducing baselines for project management, available now!
    In Product Announcements
    Hi Community,  We are excited to announce the launch of baselines - a fixed reference point in time to measure and compare a project’s progress to completion. Capturing and comparing variances between the current actual schedule and the or…
    1134 17
    1.1K views 17 comments Most recent by Tom Ward Product Announcements
  • Manpower Summation from Schedule
    In Formulas and Functions
    Hi! I have a construction schedule with the following column names: task, start date, end date, duration, assigned to, manpower. The "assigned to" column is different subcontractors such as "sheet metal subcontractor", …
    Answered - Pending Review
    78 2
    Answered - Pending Review 78 views 2 comments Most recent by Jake Anderson Formulas and Functions
  • How to get realistic timeline of the project considering the resource allocated
    In Using Smartsheet
    Hi all, First time using smartsheet and haven't been able to figure it out. I searched on this forum and seems like back in the days people had similar issues. Not sure if it's been resolved or not. Here is the issue: I have contractors th…
    Answered - Pending Review
    35 6
    Answered - Pending Review 35 views 6 comments Most recent by Tim Shaded Using Smartsheet
  • Anyone have any guidance on how best to document workflow?
    In Staying on the Same Sheet
    ... or, "SmartSheet, meet Process" I have a reasonably complex process built out in SmartSheet but need a way to: More easily document the flow, along with all branches; Create a process flow diagram from the existing SmartSheet…
    170 4
    Accepted Answer 170 views 4 comments Most recent by Ruth Barrett Staying on the Same Sheet