Discussions

Expand all | Collapse all

Formula Field: Detecting if Another Field Has Text; ""If Contains *, Then...

  • 1.  Formula Field: Detecting if Another Field Has Text; ""If Contains *, Then...

    Posted 07-05-2018 14:34

    Here's my formula idea: I want [Full Name] to display First, Middle, Last... but only show [Middle Name] if there is text in the field. Currently it shows up as an extra blank space, which doesn't look as neat. I know the first part of the formula isn't set up correctly because no middle names are showing (because no one has the middle name "*"), but this is just to get across the idea that if any text is detected, show middle name.

    If([Middle Name]="*", ([First Name]&" "&[Middle Name]&" "&[Last Name]), ([First Name]&" "&[Last Name]))

    Any help is appreciated!


  • 2.  RE: Formula Field: Detecting if Another Field Has Text; ""If Contains *, Then...

    Posted 07-05-2018 14:38
    Thats exactly what the List function is for. :)

    I puts the delimiter between non null values. 

    List (" ", [First Name], [Middle Name], [Last Name])


  • 3.  RE: Formula Field: Detecting if Another Field Has Text; ""If Contains *, Then...

    Posted 07-05-2018 15:00
    Perfect! Thanks Mark!