Calculate new start time for whole schedule
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!