Calculate new start time for whole schedule

Sascha Nachtnebel
Sascha Nachtnebel ✭
edited 10/13/20 in Formulas and Functions

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

Bildschirmfoto 2020-10-13 um 10.48.14.png


Tags:
· Share on FacebookShare on Twitter

Answers

  • Ramzi K
    Ramzi K ✭✭✭✭✭

    @Sascha Nachtnebel

    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.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!