Is it possible to get the record owner's name without code?

Question

In a case where we have Account and Opportunity object. From the Opportunity object, can we have a field that gets the Account Owner's Name without using a trigger?

I checked using a formula field and a workflow and the most that I can do in the formula is "Account.OwnerId". It won't allow me to have "Account.Owner.Name"

Answer 1

No, unfortunately, you can't access the Account Owner Name from a formula without a trigger. The trigger approach has been blogged here, and the idea to fix this for formulas is here.