When creating an automation rule it is not currently possible to update a related goal's status. Goals are the only related record type for which you cannot update the status.
In my example, I would like to update the goal status based on a change in the initiative, such as the initiative status changing to 'at risk' and therefore the goal status should be adjusted as well.
This would be a monumental value add!