In our organization a sale is considered as complete only when a custom picklist called Account status is changed to 'Registered' on an Account. (We deal with registering new companies)
Business would like a report which shows how many Leads that got converted eventually became a 'Registered' Account.
For this I need to create a formula field on Lead with logic 1) If Lead is not converted, VALUE = Status of Lead 2) If Lead is converted and account is registered, VALUE = ConvertedAccount.Account_Status__c
However, I am able to query this info from Developer Console by referencing convertedAccount.Account_Status__c
Is there any way can I make a formula to combine data from Lead and converted Account to display on a Lead Report?