Project Management

Discussion List

  • Using IFS statement with date and check box
    In Formulas and Functions
    The simple statement is I want to have a sum of work hours in a department, that is still incomplete, during a calendar period. Currently the formula is: =SUMIFS([Work Hours]:[Work Hours], Department:Department, "Wire", Finish:Fi…
    Accepted
    50 2
    Accepted Answer 50 views 2 comments Most recent by Paul Newcome Formulas and Functions
  • Time controlling
    In Using Smartsheet
    We planed a rough schedule for our project. Now we need to plan new, because of the changes in the project. Also we want overlay the old plan with a new one so we ca see consequences. So I could see it is possible to add new columns and ch…
    Accepted
    24 1
    Accepted Answer 24 views 1 comment Most recent by Paul Newcome Using Smartsheet
  • Join the new group for Control Center!
    In Apps, Integrations, and Add Ons
    We've launched a new group for Smartsheet Control Center users! We hope this is a space for you to find answers to your questions, provide help to others, and connect with people with similar interests and use cases. Ask you questions abou…
    199 0
    199 views 0 comments Started by Brian Besand - Smartsheet Apps, Integrations, and Add Ons
  • Combining multiple views of a project plan in one
    In Using Smartsheet
    In our previous solution, we had five project plans for users to choose from. This caused reporting issues as our milestones did not align between project plans. Has anyone combined project plans into one template and allowed the user to s…
    Accepted
    225 5
    Accepted Answer 225 views 5 comments Most recent by Paul Newcome Using Smartsheet
  • Start and end date columns advanced by one year
    In Formulas and Functions
    Hi all, I'm trying to flip ALL dates in the start column ahead by 1 year and ALL dates in the finish column ahead by one year. We're utilizing Smartsheet as our critical path platform so this is something we need to do year over year and …
    Accepted
    87 5
    Accepted Answer 87 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Incoming and outgoing project sheets
    In Using Smartsheet
    I am looking to implament project controls as below One (1) workspace All project sheets (no sub folders) Project control Sheet Reporting (at risk tasks, high priority tasks, hours per resource) As projects start (need to be seen on the P…
    Answered - Pending Review
    28 1
    Answered - Pending Review 28 views 1 comment Most recent by Stefan Using Smartsheet
  • Adding Time to a Project Plan via Forms
    In Formulas and Functions
    I have a normal/typical/simple project plan sheet: task, duration, assigned to. In lieu of having the Proj Mgr ask the engineer, how much he accomplished on the task and then putting that time into the project plan manually, is there a w…
    Accepted
    49 2
    Accepted Answer 49 views 2 comments Most recent by Joel Richardson Formulas and Functions
  • Count dropdown and %
    In Formulas and Functions
    Hi Community, I am defining the following formula to count how many children cells are blank out of the total number of children cells along with the associated percentage value. In a Team schedule sheet this will count how many time slot…
    Accepted
    37 3
    Accepted Answer 37 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Why is INDEX slow?
    In Using Smartsheet
    Hi, We have been using SmartSheet for many years and have developed our entire project management around it. Every production sheet is derived from the same template. Thus, every production sheet has the same columns and many of those colu…
    Answered - Pending Review
    85 5
    Answered - Pending Review 85 views 5 comments Most recent by Rob Hagan Using Smartsheet