-
Merged: Constrain Dates in project management
This discussion has been merged.
-
Target Completion Date not rolling up and duration is way off
Hi, I can't for the life of me figure out why a subsection in my project plan is not rolling up the target completion dates and somehow it's going to take over 100,000 days to complete this section. I've unhidden all cells, double checked the dates, the Dependencies look fine... I'm at a loss. The other subsections are…
-
Editing Start & End Date w/dependencies enabled
I have a worksheet with a Start & End and Project Settings set. I really need the durations and predecessors for the Gantt chart. However, I want my users, ELT, to work only from a report of Dynamic View and they need the ability to edit their dates as needed. According to the article below you can only edit the dates in…
-
Countifs statements for date fields that are in the past
Hi there, I am looking to summarize data from a master sheet for inclusion into a dashboard via a project metrics sheet. Within the master sheet I have an “Opening Date” that is populated when the opening date is decided. I want to populate the Dashboard with the number of sites that HAVE opened each month (past tense).…
-
Calculate number of days per month within a date range that spans more than one year
I have a schedule that spans (2) calendar years. I want to return the number of days per month included in the range. Since I use this result for billing purposes, I have a column per month and year of the schedule the returns the number of days in that given month/year. I am running into problems once I get to the same…
-
Project Management Certification Study Guide - are the "path" links needed to pass the exam?
Hello! I'm currently studying in preparation for the Project Management Certification exam. Having learned from the Core Exam experience, I'm focusing my studies on the suggested learning material (https://smartu.smartsheet.com/page/project-management-certification-resources). The material so far has been the expected…
-
Can I use a formula to copy the date from my "Target Date" column to my "Projected Date" column?
I'm working on creating a project status dashboard to share with stakeholders at my company so they can easily understand where each project stands. I have a "Target Completion Date" column and a "Projected Completion Date" column. I'd like to be able to use a formula so that when the "Status" column says "In Progress, On…
-
Nested if & countifs to generate a prefix based on number of occurrences
I am trying to get this part of a concatenate to work but keep getting #unparseable. The latter part of the concatenate works and generates a unique identifier for the project. However, the beginning section is meant to generate a prefix based on whether this project is the first, second (b), third (c) etc. project with…
-
Project Form - repeating row
I have a project sheet that contains the overall project name as the parent row and the smaller tasks are in child rows. I've created a form to make data entry easier for our team. Is there a way I can make the form repeat the question that asks for the smaller tasks information used in the child row? I'm assuming I will…
-
Formula to Handle SLA Due Date vs Campaign Start Date
Hi, Smartsheet Community! 👋 This is my first post. Thanks in advance to anyone offering help. Much appreciated! Lots of text ahead but I'm trying to include all relevant details and context. SITUATION We recently launched a new digital marketing request form. On the request form, there are fields for Campaign Type and…
