Activity Forums Salesforce® Discussions What are Salesforce formula fields?

  • What are Salesforce formula fields?

    Posted by D on May 3, 2019 at 9:46 AM

    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)))

    lavish replied 6 years, 12 months ago 2 Members · 1 Reply
  • 1 Reply
  • lavish

    Member
    May 17, 2019 at 9:48 AM

    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.