Date formulas
![Aaron Olsen](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I am very new to this and don't work with formulas often. I am trying to create a formula that will update the finish date automatically based on a given timeframe. For example start date is 10/12 next column gives time expected to complete task 6 weeks. I want to create a formula that will autofill the completion date in the next column. This in turn will autofill in the gantt chart calendar based on the template i'm using.
Thanks,
Aaron
Best Answer
-
If you have two date columns (of type date) and one duration column, you can use Smartsheet's built in capabilities for project management to do what you need without any formulas.
In this example, I have a sheet with Task, Start Date, Duration, and End Date.
Right click in any column header and select Edit Project Settings...
Then make sure your Start and End Date fields are filled in the Date range display
Then check the Dependencies check box and make sure your Duration column is specified in the Duration column box
That's basically it. Now enter a Start Date (in your case 10/12) a duration "6w". Your End Date will automatically calculate.
I hope this helps.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Answers
-
If you have two date columns (of type date) and one duration column, you can use Smartsheet's built in capabilities for project management to do what you need without any formulas.
In this example, I have a sheet with Task, Start Date, Duration, and End Date.
Right click in any column header and select Edit Project Settings...
Then make sure your Start and End Date fields are filled in the Date range display
Then check the Dependencies check box and make sure your Duration column is specified in the Duration column box
That's basically it. Now enter a Start Date (in your case 10/12) a duration "6w". Your End Date will automatically calculate.
I hope this helps.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
Thank you this is super helpful!
-
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!