Auto Calculate based on task being complete ahead of schedule
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.
Help Article Resources
Check out the Formula Handbook template!