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
paulmagpaulmag 

add a value to a formula - within the formula

I have the below formula which gives a score based on the type and length of our sales guys activity. I want to expand the formula to say that if they have have ticked a drive time box it will add 1 to the formula total.

 

So if this criteria is true     IF(or( No_of_people_in_meeting__c >=10), 3,

and the box is ticked the total score should be 4.

 

Can I add this to the formula or do i need to have seperate fields?

 

Thanks in advance

 

Paul

 

 

IF(AND(OR(Activity_Text__c ="Drop In"), AND(DurationInMinutes < 20)),0.33,

IF(or(Activity_Text__c ="Cancelled - notice given"), 0,
IF(or(Activity_Text__c ="Cancelled - after arrival"), 1,
IF(or(Activity_Text__c ="Admin"), 0,
IF(or(Activity_Text__c ="Roadshow"), 3,
If((Activity_Text__c ="Manager Exception"),1,

IF(or( No_of_people_in_meeting__c >=10), 3,
IF(or(No_of_people_in_meeting__c >= 2) ,2,

IF(OR( DurationInMinutes >= 300),3,
IF(OR(DurationInMinutes >= 120) ,2,
IF(OR(DurationInMinutes < 120),1,



Null)))))))))))

Best Answer chosen by Admin (Salesforce Developers) 
Ispita_NavatarIspita_Navatar

Try the following using nested if:-

 

 

IF(( No_of_people_in_meeting__c >=10), if(Drive_time_box__c ,4, 3),0)

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.