function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
LoriLynxLoriLynx 

I need help creating this field. Thank you

HI All! 
I nee help with this formula. 

Create new field in EngDev Opportunities "Units-TextEquivalent" 
Formula > Text 
Evaluate existing Units field and return text equivalent for values 1-100 
Everyone can view/edit but do not place on page layout 
Example: 
1 = ONE 
11 = ELEVEN 
21 = TWENTY-ONE
Always ThinkinAlways Thinkin
You might be able to get away with a CASE() function for this although you might get a syntax error if the complied size is too great. It would look like:
CASE( Days_As_a_Lead__c , 1 , "ONE", 2, "TWO", "NULL or OUT OF RANGE")
and require creating value-result pairs for every number 1-100.