Dependencies - Delay of one month

Hi,

currently working on a "calculator" that distributes dates based on the "Start date" input from the user.

I need to use dependencies, however I don't find a way to include 1 month as a delay (if the input date is 25/08, then the next date is 25/09).

Is there a way to achieve this ?

I was using formulas before, but you can't force a formula from a report...

Thanks !

Paul.

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hi @Kypeo

If you're using dependencies, have you looked at adding Lag Time? For example, I've added 20 working days between my dependent tasks:

Screen Shot 2021-08-09 at 1.37.26 PM.png

See the very bottom of this Help Article for more information: Enable Dependencies and Use Predecessors

Let me know if this helps!

Cheers,

Genevieve

Kypeo

Hello @Genevieve P. ,

thank you for you feedback ! I tried to use the lag but it doesn't allow me to configure exactly one month.

Depending of the month and the start date, 20 working days doesn't always work. For example : 01/01/21 + 20d = 29/01/2021.

My goal is to have the same "day of month", in the next month. In Excel it would be the EDATE function.

Paul.

Genevieve P.

Hi @Kypeo

Formulas cannot be placed in Predecessor columns that are being used for Dependencies (see: areas where formula use is restricted).

This means that you would need to identify how many working days would equal one month to manually add that as lag time within the Predecessor column.

For example, 01/01/21 where you add 21 working days will then come to 03/02/21. This is because 01/02/21 is a weekend, so the next task will start on a working day:

Screen Shot 2021-08-09 at 3.05.25 PM.png

If you were not using dependencies, you could use a formula to add 1 month to the date. Here's a help article that goes through working with Dates in Formulas, and another one on the MONTH function. Let me know if you want to go down that route instead and I'm happy to help.

Cheers,

Genevieve

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.