Project Management

Discussion List

  • Copy parent row only
    In Formulas and Functions
    I have automation set up to copy rows marked as "key deliverables" in my project schedule into a separate, key deliverables status tracking log. Unfortunately, when a key deliverables row in the schedule is a parent row -- i.e., …
    Answered - Pending Review
    13 3
    Answered - Pending Review 13 views 3 comments Most recent by John DeRoy Formulas and Functions
  • Card View for Reports
    In Using Smartsheet
    All,  Has there been any progress with adding card view to reports?  Has this been an approved feature and scheduled for a release? Our company has been pushing a move to JIRA because of the gap with smartsheet in allowing our teams to vi…
    1443 18
    1.4K views 18 comments Most recent by Theresa Horner Using Smartsheet
  • Zero Formula
    In Formulas and Functions
    Where do I find the formula to have a cell display nothing when the total becomes the number zero? I have a sheet with zeros in multiple places and it clutters to much. 
    Answered - Pending Review
    764 15
    Answered - Pending Review 764 views 15 comments Most recent by Paul Newcome Formulas and Functions
  • Add date to formula
    In Formulas and Functions
    Hi I am currently using this formula =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Handed to Pathologist") I want to look at the date for the next 30 days. I have a column titled "Due Date&quo…
    17 2
    Accepted Answer 17 views 2 comments Most recent by Sara Moore Formulas and Functions
  • Averaging RGB balls
    In Formulas and Functions
    I'm hoping this is quite simple, but my simple mind is struggling to piece it together. I have a Parent Row with multiple Children but only one hierarchy below it and i want the parent row to average the status of the Red, Green and Blue …
    Answered - Pending Review
    31 6
    Answered - Pending Review 31 views 6 comments Most recent by Leibel S Formulas and Functions
  • Manpower Projections w/ Multiple Schedules
    In Formulas and Functions
    I have several projects and we are inserting the schedules into Smartsheet and linking those with various sheets. One thing I would like to create is a sheet that pulls in Crew Size from each job and for each date range display the labor …
    Answered - Pending Review
    34 3
    Answered - Pending Review 34 views 3 comments Most recent by TJ Breslin Formulas and Functions
  • Today's Date in a Dashboard
    In Using Smartsheet
    Hi,   I have recently gotten into using Dashboards within Smartsheet, amazing. Is there a way to display today's date in a widget?   Thank, Scott
    1515 16
    1.5K views 16 comments Most recent by Wobbly1 Using Smartsheet
  • Generic timeline on Gantt chart
    In Using Smartsheet
    I'm trying to put together a Gantt chart with a generic timeline (i.e., Month 1, Month 2; Week 1, Week 2, etc.) rather than actual dates. Is there any way to do this in Smartsheet?
    Answered - Pending Review
    15 1
    Answered - Pending Review 15 views 1 comment Most recent by JeremiahHorstick Using Smartsheet
  • Report Formatting
    In Using Smartsheet
    Hi everyone. Is there a way to format a report I built. I would like to change fonts and background colors?
    1298 10
    1.3K views 10 comments Most recent by Andrée Starå Using Smartsheet
  • How to view your roadmap in Smartsheet
    In Using Smartsheet
    Hi All, I have just uploaded the Agile product roadmap template from smartsheet to create my roadmap in smartsheet account. After creation, I have not been able to visualise the end product as a roadmap (see image attached). Do i need to …
    450 10
    450 views 10 comments Most recent by Tim Meeks Using Smartsheet