Project Management

Discussion List

  • How do I count how many projects are "In Progress" or "Completed" ?
    In Formulas and Functions
    HI There, I feel this should be easy to figure out but i cant seem to! PLEASE HELP?! I have a column called "STATUS" , I have a drop down menu with the following under Status STAUS On Hold In Progress Cancelled Completed How do…
    Answered - Pending Review
    26 1
    Answered - Pending Review 26 views 1 comment Most recent by Bassam Khalil Formulas and Functions
  • Due Date Automation for Tasks
    In Formulas and Functions
    Hello: I have 2 quick questions regarding how to best automate/populate dates for project management timelines. Is there a feature (or formula) within Smartsheets that allows you to specify if a task is a reoccurring item? For example, if …
    Accepted
    191 10
    Accepted Answer 191 views 10 comments Most recent by Andrée Starå Formulas and Functions
  • Specifying a day to use with predecessors
    In Using Smartsheet
    Hi folks - Anyone know if it's possible to specify a day for an activity to happen in a sequence, when using predecessors in project plans? We have an IT review process that only happens on Mondays, and I'd like to set the predecessors fo…
    Answered - Pending Review
    17 3
    Answered - Pending Review 17 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Best Practices for managing 60+ projects in Smartsheet
    In Using Smartsheet
    Hello, I am a fairly new user of Smartsheet and have recently started at a construction company as a project manager where we design manufacture and erect large steel buildings for rural and industrial use. (From farm sheds through to airc…
    Answered - Pending Review
    81 9
    Answered - Pending Review 81 views 9 comments Most recent by Andrée Starå Using Smartsheet
  • Show ONLY Tasks in a Date Range
    In Formulas and Functions
    Is there any formula and/or filter that will enable me to show only the tasks that are scheduled to happen during a particular 3 week time frame, much like a 3 week lookahead. I want to show tasks that, during the time frame, have the foll…
    Answered - Pending Review
    51 2
    Answered - Pending Review 51 views 2 comments Most recent by Wesley Cross Formulas and Functions
  • Index Match or Index Collect with multiple criteria
    In Formulas and Functions
    I'd like to return a Contact to a cell if two criteria are met. I've tried using the index collect formula copied below but I continue to receive #INCORRECT ARGUMENT SET. =INDEX(COLLECT({Vendor Contact}, {Project Name}, [Project Name]@row,…
    Answered - Pending Review
    1441 22
    Answered - Pending Review 1.4K views 22 comments Most recent by Paul Newcome Formulas and Functions
  • Update on: Edit a reports without access to the underlying Smartsheet.
    In Using Smartsheet
    Is there any update on this function or a new workaround? Please see here: https://community.smartsheet.com/discussion/5916/editing-reports-without-having-access-to-the-underlying-sheet or https://community.smartsheet.com/discussion/17606/…
    Accepted
    57 4
    Accepted Answer 57 views 4 comments Most recent by Laura Bell Using Smartsheet
  • Formulas -Automated at risk status
    In Formulas and Functions
    Hi all, I'm quite new and I'm struggling with a formula I need to apply. I need to have an automated "at risk" status (red, yellow, green) in my projects masterlist. Red: % Done is equal to 0% and the Start Date has passed Yello…
    Accepted
    27 3
    Accepted Answer 27 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Formulas for % Allocation in Resource Manager
    In Using Smartsheet
    Is it possible to use a formula to generate a percentage in a % Allocation column for use in the Project Resource Manager? Or does a percentage have to be manually entered into the % Allocation column? I've done quite a bit of research on …
    Accepted
    44 4
    Accepted Answer 44 views 4 comments Most recent by Deanna Bowman Using Smartsheet