How to Make start date = dependency date

9

Hi @Ryan_Redmond,
glad to hear that :slight_smile:

The problem with a mix of input and formula columns is the way you deal with them, as a column can’t be both.

In your case, if you want an overall consistent information about dates, you might want to add another two columns (yes…) - such as Actual Start and Actual End - and the basic rule you want to be applied: if Dependency overrides the manual date or vice versa.

So, for instance, for the Actual Start:
Dependency.Start.IfBlank(Manual Start)

At that point you only consider consistently Actual Start|End pairs.

I hope this helps.

Cheers!