• toddring
  • NEWBIE
  • 0 Points
  • Member since 2009

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 2
    Replies
Hi. Apparently long text fields are not supported in list views or formulas.
Error: You referenced an unsupported field type called "Long Text Area" using the following field: Description
I'm trying to develop a formula that will display the first sentence from a long text field.
I thought that I could use a FIND function to locate the first period, then return the text before that.
But, the long text field that I'm looking for is not shown as a field that I can insert. (I want to use Lead > Description) So, I just typed it in.

Some of my users have leads that are the same except for the description, and I'm trying to figure out a better way for distinguishing them from a list view. Otherwise they look like dupes. I don't want to add an extra custom text field that they have to enter.

Thoughts on how to resolve? Alternatives? Thanks in advance.