I am struggling finding a formula to mark the successor task "In Progress" when predecessor is "Complete" like can be done in MPP. I am encouraging my organization to move to SS with the automation, reporting, dashboard and automation capabilities, and away from MPPP so trying to replicate some of the items they utilize in MPP.
Here is the current sheet I am trying to update when the predecessor completes, mark next task to "In Progress". Can we do this in SS? If so, HOW? If not, any suggestions of how to overcome this objection?
