Target Start/End Date

Ultimately, I need a good way to track if we are completing tasks on time based on our original estimates because we have users that estimate a task will take 5 days and when it takes 15 they just change the dates, and the project status still looks green, when is reality it is behind.

I would like to have target start/end date columns that work exactly like the default Start Date & End Date columns, meaning I want the parent rows to populate based on the smallest date in the start column and the largest date in the end column.

I have also added a Health column to provide a visual of whether the task was completed on time or not. Here is the formula for that column, which seems to be working correctly. =IF(ISBLANK([End Date]@row - [Target End Date]@row ), "Gray", IF([End Date]@row - [Target End Date]@row >= 10, "Red", IF([End Date]@row - [Target End Date]@row <= 0, "Green", "Yellow")))

Find more posts tagged with

Formulas

Project Management

Accepted answers

All comments

Erin Horiuchi Green

@mel_berk In the Smartsheet Learning Center, Level 1 Foundations section 3 Rows and Hierarchy notesthe impact of start/end dates when dependencies are enabled. Screenshot below.

Resources:
1) Activate Dependencies and user Predecessors in Grid and Gantt View
2) Project Settings in Grid and Gantt View

mel_berk

@Erin Horiuchi Green, I have dependencies enabled but that behavior is only working on my Start Date & End Date columns. I also want that rollup to work on the Target Date columns.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.