-
What are Salesforce formula fields?
i have text string divides with slashes ,
string contains in one text field by using formula field i need to show from last two slashes text ..
EX :Default Category/Home Video,Default Category/Home Video/Blu-ray/DVD,Default Category/Home Video/Limited Editions
Here :o/p Home video/Limited Editions
Here text varies from record to record ...
i written like :LEFT(RIGHT(Category__c,LEN(Category__c) - FIND("/", Category__c)),
FIND("/",RIGHT(Category__c,LEN(Category__c) - FIND("/", Category__c)-1))) -
1 Reply
-
I think we can't achieve it with requirement field formula. It's an interesting question. It would be great to learn about it more.
Log In to reply.
Popular Salesforce Blogs
Salesforce B2B Commerce Cloud for Modern Businesses
In the fast-paced world of digital commerce, businesses are constantly seeking innovative solutions to enhance their online presence and streamline their operations. Salesforce B2B Commerce…
New Salesforce Agentforce Accelerator Empowers Nonprofits for Greater Impact
Salesforce has launched the Agentforce Accelerator for Impact, an initiative to help nonprofits harness Agentforce, an innovative AI layer on the Salesforce Platform. This technology…
Debug and Deployment Tools in Salesforce
Development Tools In Salesforce 1. Developer Edition Environment You may start designing and testing your software-as-a-service application right now in this online environment. Designed for…
Popular Salesforce Videos
Driving Sales Productivity and Motivations from Your Salesforce Data
Meet OneUp Sales, the revolutionary sales motivation platform built for modern sales teams. By leveraging data extracted from systems you already use, OneUp powers lively…
Guided Setup with Salesforce Field Service Administration - Webinar Recording
Salesforce Field Service is a complete, end-to-end solution for customer service in the field. Salesforce Field Service brings together customers, employees, and products on a…
EPC and CPQ in Salesforce Industries (Vlocity)
Enterprise Product Catalog (EPC) to configure and manage CPQ in one place. It's a guided selling experience for users to build an order. While CPQ…
