Project Management

Discussion List

  • Creating a Burn Down Chart
    In Using Smartsheet
    Hello, I'm a bit stuck on how, if it is even possible, to create a burn down chart. I'm importing raw data from Jira (we don't have the plug-in... yet) and we want to show a burn down of our defects backlog, along with optimistic and pess…
    4152 28
    4.2K views 28 comments Most recent by Unnati R Using Smartsheet
  • Time Tracking - Hours and Minutes
    In Formulas and Functions
    I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-ar…
    1419 5
    1.4K views 5 comments Most recent by L_123 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…
    552 12
    552 views 12 comments Most recent by Roland Horwood Using Smartsheet
  • =COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) Formula help!
    In Formulas and Functions
    Currently using =COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) with check-boxes as a quick look to tell how many deliverables have currently been accounted for. I need to add additional lines under the parent row, but don't…
    Answered - Pending Review
    16 1
    Answered - Pending Review 16 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • Setting predecessors with multiple tasks
    In Formulas and Functions
    I would like to have Task D begin when Task A or Task B is completed. How can I set multiple predecessors? Task Name | Start Date | End Date | Duration | Predecessor Task A | 7/1/2021 Task B | 7/11/2021 Task C | Start Date should be 7/1…
    Answered - Pending Review
    31 1
    Answered - Pending Review 31 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • Bring Task to a separated Smartsheet if due date
    In Formulas and Functions
    Hi, I have several tasks Smartsheet's to manage different projects. In order to avoid keep checking each Smartsheet for due dates, I would like to have a "Summary" Smartsheet that brings only tasks that are about to get due. How …
    Answered - Pending Review
    14 1
    Answered - Pending Review 14 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • 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
    180 7
    Answered - Pending Review 180 views 7 comments Most recent by Rene Lara Formulas and Functions
  • How to combine multiple excel sheets in one smartsheet?
    In Using Smartsheet
    Hello, I am trying to create one master sheet in smartsheet. I have 10 excel sheets with identical column names. I have created one master sheet with the same column name. How can I combine all those sheets in one smartsheet? Is there any …
    Answered - Pending Review
    17 1
    Answered - Pending Review 17 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Edit contact display?
    In Using Smartsheet
    Hi Do you know if you can edit the display of a contact in an assigned to column? Ideally I just want to see the initials in the icon and not the name/ email that follows. Thanks, Jo
    625 5
    625 views 5 comments Most recent by Genevieve P. Using Smartsheet
  • Help w/multiple if statements
    In Formulas and Functions
    Hello! I am a new Smartsheet user trying to figure out if multiple if statements work with what I'm trying to do. I would like to automate the date in the Release to SGS/Printer column based on what is in the Materials in House column and …
    13 3
    Accepted Answer 13 views 3 comments Most recent by Genevieve P. Formulas and Functions