I was wondering if there is a way to enforce the order of the values that the formula returns, as the basic values are only able to be sorted alphabetically in the Salesforce report!
1 risposta
Hi Kelly
The only way I can think of is to create an auto number field.
Format:{0}
Starting number: 1
And make sure you select the box to update old records.
Then you could change your formula like so
AutoNumberField__c&' - '& BLANKVALUE(Opportunity.Funnel_Stage_Name__c, Lead.Lead_Status_2__c)
Now, if you sort your report by that column, you can sort from the oldest or newest record, but that implies that is the order you want.
