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.
Smartsheet Partner | More than 7 years of expertise
Answers
-
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:
See the very bottom of this Help Article for more information: Enable Dependencies and Use Predecessors
Let me know if this helps!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
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.
Smartsheet Partner | More than 7 years of expertise
-
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:
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!