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개
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.
