I want to implement automation rule to achieve below:
There isn't a means of accomplishing this with automation. Maybe, if using a company managed project you could rethink the solution and leverage a cascading select field.
It looks like you're new here. Sign in or register to get started.