function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Formula to extract certain characters from the Task Description Field using TRIM

Here is my formula to extract first few lines from the TASK Description (Standard) Field.


TRIM(RIGHT( Description , 200))


The above works but not exactly.


I get the content which starts from the middle of the paragraph. How can I write this?


Hi Sudha,


RIGHT( Description , 200) would return  the specified number of characters from the end of the string.


If you need the first 200 characters you would have to use LEFT(text, num_chars).