Duration and Date Dependencies - Reference Cell in Same Sheet

Hi,

Very novice user here.

I am using Dependencies and am trying to find a way to make the Duration and Start/Complete Dates reference another cell within the same sheet. Screenshot attached.

I'm trying to have the information in the Project Summary cells pulled into highlighted durations/dates so that it doesn't have to be remembered and input a ton of times.

It seems that I can't use a formula in the Start Date, Complete Date, Predecessor or Duration columns since Dependencies are enabled, but I'm hoping there's a workaround since all I'm looking to do is pull the durations/dates from a cell within the same sheet rather than it being an actual formula.

Thanks for the help!

Find more posts tagged with

Construction

Formulas

Real Estate

Project Management

Cell linking

Accepted answers

All comments

che.rabajante

Hello @mmathis

You need to create a separate sheet for inputting the Project Summary information.

In your current project sheet, you can then link this information from the Project Summary (another sheet) to Duration or Dates columns. When dependencies are enabled, formulas doesn't work with duration and dates, they work when directly linked from another sheet.

Hoe this helps!

che

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.