You need to sign in to do that
Don't have an account?
Robert Wynter
formula function to pick a number between 1 and NumberOfLeads , which is the number of leads ina campaign
I have a checkbox and I want to create a formula that if the checkbox is checked. the formula will pick a number between 1 and NumberOfLeads
I have understood your requirements. In Campaign, I made a checkbox and a formula field.
1. Checkbox -
Label - want to count?
2. Formula field
Label - Count random
formula is -
IF((Want_Count__c==true) ,IF((NumberOfLeads-1)<=0 ,null,(NumberOfLeads-1)) , null )
It will generate a no in between 1 and NumberOfLeads.
For more help, feel free to ask.
I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks and Regards,
Ajay Dubedi
www.ajaydubedi.com (http://www.ajaydubedi.com )
All Answers
I have understood your requirements. In Campaign, I made a checkbox and a formula field.
1. Checkbox -
Label - want to count?
2. Formula field
Label - Count random
formula is -
IF((Want_Count__c==true) ,IF((NumberOfLeads-1)<=0 ,null,(NumberOfLeads-1)) , null )
It will generate a no in between 1 and NumberOfLeads.
For more help, feel free to ask.
I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks and Regards,
Ajay Dubedi
www.ajaydubedi.com (http://www.ajaydubedi.com )