Auto Calculate based on task being complete ahead of schedule

Options
Rob M W
Rob M W
edited 10/20/22 in Formulas and Functions

 I am somewhat new to SS 1st and foremost.

In the example row 88 is completed ahead of schedule. (Task=complete and % Complete=100%) Row 90 task is driven from the completion of task 79 “Manual Set-up Station”.

What is the right way to set this up so that if we are ahead of schedule and we have resources I want the start of row 90 to be 10/22 based on 100% complete on row 79?

Our goal is to have the manufacturing team update SS and not make the process difficult for them. Updating the % Complete is more than doable for them. Having them update dates is not something we want them to do.

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Options

    What exactly is the problem, and what exactly are you wanting to accomplish?

  • Rob M W
    Options

     I am somewhat new to SS 1st and foremost.

    In the example row 88 is completed ahead of schedule. (Task=complete and % Complete=100%) Row 90 task is driven from the completion of task 79 “Manual Set-up Station”.

    What is the right way to set this up so that if we are ahead of schedule and we have resources I want the start of row 90 to be 10/22 based on 100% complete on row 79?

    Our goal is to have the manufacturing team update SS and not make the process difficult for them. Updating the % Complete is more than doable for them. Having them update dates is not something we want them to do

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    edited 10/21/22
    Options

    Hi @Rob M W,

    If I'm understanding right....

    "What is the right way to set this up so that if we are ahead of schedule and we have resources I want the start of row 90 to be 10/22 based on 100% complete on row 79?"

    For this you will want to use the Predecessor column. In the Predecessor column for row 90, enter 79. Then once the end date for 79 is entered, the start date for 90 will be updated to the next working day after the completion of row 79.

    "Our goal is to have the manufacturing team update SS and not make the process difficult for them. Updating the % Complete is more than doable for them. Having them update dates is not something we want them to do."

    If you want a team to use Smartsheet, and need to ensure they don't touch any specific column; there are a couple different options. 1.) Dynamic View, if you have this in your plan. 2.) Use a Report, and only include the columns you want that team to see/update. Then share the report with them, and ask them to make their updates there (Edit access to the underlying sheet is still required).


    Hope this helps!

    All the best,

    -Ray

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!