You need to sign in to do that
Don't have an account?
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)))))))))))
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.