Calculate new start time for whole schedule
Hi there!
As an event organizer, I want to automatically update my schedule in smartsheet when a session takes longer than expected.
Column 1: Start Time (HH:MM)
Column 2: End Time (HH:MM)
Column 3: duration in minutes
Column 4: new start time (HH:MM)
how can I arrange a formula so that once entering a new start time in Column 4, the rest of the schedule changes? Basically, I need the exact functionality that is already there with start date, end date, duration and predecessor.
Thanks in advance!
Sascha
Answers
-
If this is a project sheet (i.e. using Smartsheet's project settings and functionality), you will not be able to put formulas in the duration or end date columns. You will need to make your changes manually.
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!