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
StaceyUSStaceyUS 

Formual Field Type - PLEASE HELP!

Hello,

 

I need help in trying to create a text formula field based off of the criteria in another field.

 

Example:

If the Reported Number of Employees <= 199 then the field would update to "Under 199", etc...

 

Any help would be appreciated.

 

Thank you.

Stacey

Best Answer chosen by Admin (Salesforce Developers) 
Steve :-/Steve :-/

Okay, you did not give me every increment between 2500-10000 so this is all I could do

 

IF(RNoE__c < 199, "Under 200",
IF(RNoE__c <= 499, "200 - 499",
IF(RNoE__c <= 999, "500 - 999",
IF(RNoE__c <= 2499, "1000 - 2499",
NULL))))

 

PS.  Oh and by the way, I like to drink these -> 

http://beeradvocate.com/beer/profile/863/7971  

 

All Answers

Steve :-/Steve :-/

Here's a real basic one you can start with:

 

IF(Reported_Number_of_Employees__C <= 199, "Under 199", "Over 199")

 

What is the field that you're trying to evaluate, what datatype is it (number, text, picklist, etc.) and what values do you want to return/display in your Formula field?  

 

PS.  You owe me a beer! ;-p
StaceyUSStaceyUS

Hello Steve,

 

The *Reported Number of Employees field is a number field type.

 

*RNoE field is <= 199 then the new formula field would = "Under 199"

*RNoE field is between 200 & 499 then the new formula field would = "200 - 499"

*RNoE field is between 500 & 999 then the new formula field would = "500 - 999"

*RNoE field is between 1000 & 2499 then the new formula field would = "1000 - 2499"

and so on up to 10000...

 

Thank you for the quick reply.
Steve :-/Steve :-/

Where's my beer??? ;-p
StaceyUSStaceyUS

If you can help me figure this out, then I definitely owe you a beer.
Steve :-/Steve :-/

Okay, you did not give me every increment between 2500-10000 so this is all I could do

 

IF(RNoE__c < 199, "Under 200",
IF(RNoE__c <= 499, "200 - 499",
IF(RNoE__c <= 999, "500 - 999",
IF(RNoE__c <= 2499, "1000 - 2499",
NULL))))

 

PS.  Oh and by the way, I like to drink these -> 

http://beeradvocate.com/beer/profile/863/7971  

 

This was selected as the best answer
StaceyUSStaceyUS

Thank you so much for your help!!!

 

I was able to figure out the remaining portion of the formula.

 

Yay!!! No Syntax errors.

 
Steve :-/Steve :-/

So when can I be expecting my beer?
StaceyUSStaceyUS

Is there a local store in your area that sells it?
Steve :-/Steve :-/

unfortunately no...  :-(  It's next to impossible to find anything from Russian River outside of No.CA  

 

But if you're going to Dreamforce '11 in August the drinks are on you!  http://www.salesforce.com/dreamforce/DF11/

 
StaceyUSStaceyUS

We were actually just talking about Dreamforce earlier today and we are looking to attend this year if our schedules allow it. 

 

Either way, I will make a note to myself as a reminder and I won't forget about you.
Steve :-/Steve :-/

I'll create a time-dependant Workflow Rule to remind you...
Steve :-/Steve :-/

I'll also settle for any Local Brews from your neck of the woods (wherever that is)
StaceyUSStaceyUS

I'm in FL.

 

We do have a store called Total Wine here that has tons of imported beer from all over.
Steve :-/Steve :-/

Thanks, I'll keep that in mind the next time I write you a chunk of code ;-p  

 

 

PS.  I'm especially fond of Imperial I.P.A.'s  ;-)