Workflow and Dynamic Cell Access
I would like to set up process control for forecast planning. For example, after operating unit users submit operating units' report, they can not edit any more. Then division users review and edit the operating units' report and then submit total divisions' report. And division users and group users can see the reporting status of all units. I first investigated dynamic cell access and thought they can check a box to submit the figures which will trigger read access only for the individuals. But the workflow function to operating unit list seems to be solution to this as well. Any suggestion on this?