Adding Hour Duration to your project schedule and predeccesors
Hi I am attempting to move our production schedule from MS Project to Smartsheet. But I am having difficulty with showing the start times and finish times per task and have it auto-update based on the hours manually entered into the sheet..
The duration column reads days only, and the sheet only shows start date and finish date based on this column. I would also like it to show the start time of the job, say 6am, if duration is 3 hours then finish time is 9am, and so on.
see below snapshot of my smartheet as it is, with a snapshot of our MSProject schedule
Answers
-
Hi @JM1
I answered your other post, here, as well. Smartsheet doesn't currently have the ability to set Time along with dates as the Start/End of tasks. You can set a Duration to be in hours (ex. 3h) on a specific day, but it won't show what hours those are. This could be identified in a separate helper column, if needed.
If you're using Smartsheet to track resources over time and dates, I would recommend looking into Resource Management by Smartsheet and the Resource Management Panel.
Cheers,
Genevieve
Need more information? 👀 | 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
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!