Project Management

Discussion List

  • Quickbooks & Smartsheet
    In API & Developers
    So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use.  It has many application & the proof of concept exists and we use it.  We use it for an approval process (for in…
    4232 30
    4.2K views 30 comments Most recent by JeremiahHorstick API & Developers
  • Date Modified
    In Formulas and Functions
    I have a sheet with a list of assets. There is a pull down menu that defines the status - I need to know when the menu is set to "complete". I can do that easily with a filter - but I want to cull the entries before a specific da…
    2494 11
    2.5K views 11 comments Most recent by PeterNYU Formulas and Functions
  • Aggregate Status Circles w/ Formula
    In Formulas and Functions
    Hi, I have these multiple statuses across 4 projects (each project is one of the rows) within 1 program and I want to be able to incorporate a formula where I can summarize all of these to a single row with the same columns in a separate s…
    12 3
    Accepted Answer 12 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • 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…
    3564 26
    3.6K views 26 comments Most recent by Andrée Starå Using Smartsheet
  • Proofing - Exporting Markup
    In Using Smartsheet
    Hello All,    Is anyone aware of a way to export proofing comments and markup? Currently, I have to take screen shots of the file and the comments to compare with the previous version and use for archiving purposes. Thanks for the assis…
    327 9
    327 views 9 comments Most recent by T_ammon Using Smartsheet
  • COMPLEX INDEX/MATCH arguments issue: Project Updates Tasklist
    In Formulas and Functions
    @Paul Newcome @Paul Newcome I need your expertise My manager has tasked me with referencing data from a hierarchy of rows, for multiple columns, but wanting the Parent Row to be updated from the inputs of the data in the CHILDREN rows, wh…
    15 3
    Accepted Answer 15 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Can I hide predecessor lines in a gantt chart?
    In Using Smartsheet
    I have a complicated project with tons of predecessors.  The predecessor lines connecting tasks in the gantt view are so numerous that is makes the gantt visually hard to use.  Is there are way to hide or turn off not the predecessors, but…
    1354 10
    1.4K views 10 comments Most recent by Jenna123 Using Smartsheet
  • Seeking consultants
    In API & Developers
    We're an organisation responsible for government facilities management, asset management and projects . We currently use Smartsheets but require refined and custom built business solutions to assist in business operations. We're seeking ex…
    Answered - Pending Review
    26 3
    Answered - Pending Review 26 views 3 comments Most recent by Darren Mullen API & Developers
  • COUNTIF Formula for Contact Column
    In Formulas and Functions
    I have several tasks set up for team members using their email addresses in the Contact column. Some tasks have 1 member assigned and some have multiple. I have to run each person's workload and am trying to use a separate sheet that count…
    1306 11
    1.3K views 11 comments Most recent by Genevieve P. Formulas and Functions
  • Project Management Office Template - Silly Question
    In Using Smartsheet
    Hi Community!! I'm working my way thru setting up a project portfolio using the Project Management Office template which is amazing! I have sort of a silly question......the Intake Form and Project Intake Sheet request something called a …
    28 3
    Accepted Answer 28 views 3 comments Most recent by Paul Newcome Using Smartsheet