I have 10 checkboxes that I need a value assigned to each (Between 1 - 3 points) depending on the box selected. Then i need a formula that will automatically assign an account level (Beginner 0-10 points, medium 11-20 points, advanced 21-30 points) based on which checkboxes are selected
Your first formula will be as below
IF(Checkbox1__c, 3,0) + IF(Checkbox2__c, 2,0) + and so on IF(Checkbox10__c, 1,0)the general format is
IF(CheckboxField__c, x,0) where X is the number of points assigned if the checkbox field is checked
Now, create a 2nd formula field as below
IF(FormulaField__c <= 10, "Beginner", IF(FormulaField__c <= 20, "Medium","Advanced" ) )There is a good chance that you may hit the formula compilation limits when you create the 2nd formula in that case you will need to do the below
Create a custom number field on the Object and label it something like total score and update this field using the workflow with a field update operation
use the first formula to update this field
save and activate the workflow rule
Now use the 2nd formula as it is.
How can I fix this chart/report to have two bars stacked next to each other (actual vs goal) - currently I'm restricted.
Not getting option for target formula?
Looking at the screenshot look like Q3 Target is a CSF field with number format
change the format of the CSF field Q3 Target to Currency
you will now be able to select this field in the combination chart.
with combination charts using bars you will need both columns to be of same data type.
Designed for users who require full access to standard CRM and Force.com AppExchange apps. Users with this user license are entitled to access any standard or custom app.
Each license provides additional storage for Enterprise, Unlimited, and Performance Edition users.
Designed for users who need access to custom apps but not to standard CRM functionality. Users with this user license are entitled to use custom apps developed in your organization or installed from Force.com AppExchange. In addition, they are entitled to use core platform functionality such as accounts, contacts, reports, dashboards, documents, and custom tabs. However, these users are not entitled to some user permissions and standard apps, including report subscriptions, standard tabs and objects such as forecasts, leads, campaigns and opportunities. Users with this license can also use Connect Offline.
If field "DoNotCall" is check then show image banner named do not call, if "HasOptedOutOfEmail" is checked, then show image banner named do not email, if both "DoNotCall" & "HasOptedOutOfEmail" are checked then show image banner named do not call or email.
I had this working with just 2 banners previously, but I can't figure out the correct formula to determine which banner to show based on 3 criteria.
Any help is appreciated.
Please post the current formula that you have and it would be easy to work based on that formula.
Your formula will be something in the below lines
IF( AND( DoNotCall, HasOptedOutOfEmail ), Your Image banner for do not call or email, IF( DoNotCall, your image banner named do not call, IF( HasOptedOutOfEmail, your image banner named do not email,NULL ) ) )Your Image banner - this should be an IMAGE Function with the IMAGE URL included in the image function.
Recently i got some news from our sales people that the Salesforce1 App is not working as it suppose to be. When searching for accounts they get the following error. See the attached image. I tried to troubleshoot the problem. Tried to deinstall the app reinstall the app, but no success. Weird thing is when i try search for random account or to search for the same accounts as one of my sales collegue's i dont get any errors. If i try to add the sales collegue's account on my iphone i getting error. In my understanding the salesforce1 app is configurable for company's is it ? Did anyone of ran into this problem and know how to solve it ?
Hope to hear from you guys soon :)
I will suggest you to contact to your developer who developed this Visualforce page to modify that page.