Project Management

Discussion List

  • In a Gantt with many rows, how to color a date range that spans all rows in a column?
    In Using Smartsheet
    In other words, I have a developed Gantt with many rows. There's an event that I'd like to track in the Gantt that occurs over the course of several weeks. I would like to highlight that date range but not just have it on one row, I want i…
    Answered - Pending Review
    15 3
    Answered - Pending Review 15 views 3 comments Most recent by Scott Rapoport Using Smartsheet
  • Moving children rows under a different parent row
    In Formulas and Functions
    Is there a way to set up a formula that will move project status "completed" from under one parent row to another parent row named "Completed project" once the project status has been selected as completed? 
    38 2
    38 views 2 comments Most recent by Nicole Lee 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…
    2052 27
    2.1K views 27 comments Most recent by edward Holtby Using Smartsheet
  • Weather icon on calendar view
    In Using Smartsheet
    I have been using smartsheet for several years, and I would love to see on calendar view a weather icon for, al least, one week. Just like Microsoft Calendar. My projects depends on weather, so its pretty important knowing the forecast. …
    55 2
    55 views 2 comments Most recent by scott.parr83911 Using Smartsheet
  • Counting number of tasks per Assigned To contact
    In Formulas and Functions
    My task list contains parent, sub-parent, then children tasks.  The workstream leader is assigned to both the parent and sub-parent tasks, and possibly sub-tasks as well.   I need to count the number of tasks per "Assigned To" …
    600 12
    600 views 12 comments Most recent by Ollie Cater Formulas and Functions
  • 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
    980 17
    Answered - Pending Review 980 views 17 comments Most recent by Paul Newcome Formulas and Functions
  • missing source appearing on Dashboard
    In Using Smartsheet
    A dashboard that I use daily now appears with "missing source" in a number of places and I have double checked the source is not missing and I am the owner of the dashboard and the source as they appear in the same workspace?! T…
    460 10
    460 views 10 comments Most recent by DaVViD Using Smartsheet
  • Email address (mailto: link) in Dashboards
    In Using Smartsheet
    Hi -  Have there been any updates on being able to enter an email address (mailto: link) in Dashboards. I would like to add Key Contacts for the project in a Rich Text Widget and include links to emails for those contacts.  I've tried bu…
    1495 12
    1.5K views 12 comments Most recent by Kirsten Kincaid Using Smartsheet
  • Simple RAG status
    In Formulas and Functions
    Hi all, I am looking to create a RAG status, based on start date of a task. Rules would be: If start date is over a week away, status is GREEN If it's within one week of the start date is YELLOW If start date is in the past is RED I also h…
    Accepted
    13 12
    Accepted Answer 13 views 12 comments Most recent by Ollie Cater Formulas and Functions
  • RTF in Dashboard Widget
    In Using Smartsheet
    I downloaded an example dashboard which tracked multiple projects.  Looked good and decided to build my dashboard to match example.  Example dashboard has a Rich Text Widget which has multiple formats within.  However when I try to use the…
    282 9
    282 views 9 comments Most recent by Roland Horwood Using Smartsheet