Auto Date Calculation

Paul Raphael

Hi,

I have 3 column's - Days, Start Date, Completion Date. I would like to enter days and start date, and let Completion date auto calculate. So for example if I enter 30 in days and 6/14 in Start Date, I would like Completion Date auto calculate to 7/14. Any tips on the right formula for this?

Thanks!

Paul Newcome

As long as the [Completion Date] column is a date type, you can enter the following into it...

=[Start Date]@row + Days@row

Paul Newcome

As long as the [Completion Date] column is a date type, you can enter the following into it...

=[Start Date]@row + Days@row

Paul Raphael

Perfect, thank you so much!

Paul Newcome

Happy to help! 👍️

Fletcher Boll

@Paul Newcome I am having trouble getting this to work.

I have dependencies set to my [Proj. Start Constr] column and [Proj. Store Open] and I have [duration (days)].

The first thing that is happening is that when I enter a proj start constru date, it automatically copies in proj store open. How do I stop this? I would like for proj. store opens to calculate based on start constr and duration.

I've tried:

=[proj. start constr]1+[duration (days)]1

=(proj. start constr]1+[duration (days)]1

=[proj. start constr]1+45

Nothing is working :( 🙏

Screen Shot 2020-02-04 at 9.21.33 PM.png

Screen Shot 2020-02-04 at 9.19.45 PM.png

Screen Shot 2020-02-04 at 9.19.37 PM.png

Paul Newcome

@Fletcher Boll Formulas cannot be entered into columns that are being used by the dependency settings. To be able to use formulas in those columns, you would need to either look at different columns in your dependency settings or turn them off completely.

Fletcher Boll

@Paul Newcome Can I still use those dates for gantt view if dependencies are turned off?

Thank you for responding!

Paul Newcome

@Fletcher Boll Yes. The dates would still work in Gantt view.