Ask Search:
Steve MolisSteve Molis 
The "Check Syntax" button in the Formula Editor only tests the Syntax of a Formula, not the Formula Logic.  

For example both ( A + B ) / C and  A + ( B / C ) are Syntactically correct, but they will return completely different (and potentially bad) results. 

Validation Rules are boolean, and so are Checkbox fields.  So if you ever want to test the Logic of a Validation Rule Formula, just create a hidden Formula Field that returns a Checkbox result and then put your Validation Rule Formula in it.

Then create a Report or a List View that displays all of the fields that your Validation Rule is evaluating, and your Formula(Checkbox) field side-by-side to check for loopholes.
User-added image

*** Caveat Alert *** 

Not all Functions, like ISCHANGED and PRIORVALUE are supported in Formula Fields 
Best Answer chosen by Jayson ( 
Steve MolisSteve Molis
PS.  I've added the Validation Rule Test custom Formula(Checkbox) field on most Standard Salesforce objects in the Autumn'19 release of my Custom Formula Field Mix-Tape unmanaged package

The package is free, but if you really like it and are feeling generous, there's a link to my PayPal in the package (no obligation)

Install URL =
Password = UoweB33R

User-added image
Sharon AylwardSharon Aylward 
A number of acquisitions mean that our company has multiple instances of Salesforce but wants one reporting output. Is there a way that this can be achieved?
Best Answer chosen by Sharon Aylward
Pruthvi RajPruthvi Raj
@SHARON: So each instance will have different reports which will view/return their own instance's data. So YES the results couldn't be viewed in one report.
Jisu JeongJisu Jeong 
How can i create a Custom Field on the Lead Object?
Best Answer chosen by Jisu Jeong
Quratulain TariqQuratulain Tariq
Hello Jisu

In Classic:
To add a custom field on the Lead Object, please go to Setup> Type Lead in the Quick Find/Search box on the top-left> Click on Fields under Lead> Scroll down to Lead Custom Fields & Relationships section and click on New button. From there you can select field type, set name and create a field. 

In Lightning:
To add a custom field on the Lead Object, please click on the gear icon on the top right then select Setup> Click on Object Manager> Find Lead from the objects list and Click on it> From the options on the left Panel select Fields & Relationships and Click on the New button on the top rightFrom there you can select field type, set name and create a field. 
Steve MolisSteve Molis 
User-added image

Opportunity History Reports are f*cking awesome, they allow you to see the complete lifecycle of the Opportunity tracking changes to the "core" Opportunity Metrics: Amount, Stage, Close Date, Probability%, Forecast Category. And unlike Field History Reports they're available right out of the box and immediately have access to historical data from "Day 1" of your SFDC org.  In other words: they work retroactively.  They also have more robust Field Filtering, and access to Cross-Filters (they also don't look like they fell out of the top of the Ugly Tree and hit every branch on the way down).
However Opportunity History Reports do have an Achilles’ Heel:  You can’t easily see or filter by the current Stage, Amount, Probability%, Close Date, Forecast Category.  But you can do this (and whole lot more!) just by adding a few simple Formula Fields to the Opportunity Object.  Now some folks are probably saying: 

“I don’t want to add more formula fields, I don’t want my Opportunity to look like a Race Car at the Daytona 500!”. 

Here’s the thing; you don’t need to add the new fields to the Opportunity Page Layout, you just need to give the Users/Profiles “Read” access to the Data in the fields.  So you can keep your precious Opportunity Page layouts as pure as the driven snow in an Ansel Adams landscape.
Anyway, it's just an idea that I came up with.  I’m like Leonardo DaVinci, my mind is full of ideas...  although most of them are about as useless as a Wooden Helicopter powered by ropes and pulleys. 
And now without further ado here are the fields:
Current Stage
Datatype = Formula
Result = Text
Formula = TEXT(StageName)
Current Close Date
Datatype = Formula
Result = Date
Formula = CloseDate
Current Probability%
Datatype = Formula
Result = Percent 0 decimals
Formula = Probability
Current Amount
Datatype = Formula
Result = Currency
Formula = Amount
Current Forecast Category
Datatype = Formula
Result = Text
Formula = TEXT(ForecastCategoryName)  

User-added image
Best Answer chosen by Miglena ( 
Steve MolisSteve Molis
Hi Nate,
If you need a report that shows the current Stage, Close Date, $Amount, Probability% and the historical changes to those fields in 1 Report.    

For eaxmple:  Yuo need a Report of all Opportunities that are currently in the Negotiation/Review Stage with the complete History of Stages, $Amount, Probability, Close Date, etc.  

With a standard Opportunity History Report if you Filter the Report by "To Stage" [equals] Negotiation/Review you'll get any Opportunity that was ever in the Negotiation/Review stage regardless of what Stage they are currently in. 
Kevin OakKevin Oak 
Hello, I need a little help building a report/graph. We have a need to show not reviewed alerts over the past 10 months broken up weekly or monthly. I have a report that has a team of ~5 users and shows their total not reviewed alerts in the past 10 months. Is it possible to show a trend for each user in the report i.e Joey in Jan had x amount and feb x amount etc etc.. for each user? If you look at the graph I want each user to have a month and how many missed alerts per month over the course of 10months.
User-added image
User-added image
Best Answer chosen by Kevin Oak
David HolmesDavid Holmes
Hi Kevin,

If you group by your date field in the report you can click on the drop down next to that field in the table itself and "Group Date By" then choose month.

User-added image
Tom DropikTom Dropik 
I created a report using the Case Lifecycle report type. This allows me to include the field Business Hours Duration in the report.

It turns out, after opening a case with Salesforce, that the Business Hours Duration field is being calculated using the Default Business Hours even though the Case is associated to the Non-Default set of Business Hours.

Is it true that even though a Case is associated to a set of Business Hours that are NOT the Default Business Hours, the Business Hours Duration field is calculated off the Default Business Hours?
Best Answer chosen by Miglena ( 
Jeff MayJeff May
Yes it is true: (
Larissa JohnsonLarissa Johnson 
Is there a solution to default the toggle chart to "off" for reports in Lightning? I have reports which we do not have a report chart built in the report for, but everytime I open the report it defaults to a standard chart on the report. I would prefer the default be off, but can't find a way around this.
Best Answer chosen by Larissa Johnson
Erick BurtnessErick Burtness
I was able to work around this by editing my report and switching it to Tabular format so there was no grouping available for a chart, running it, saving it, then switching back to Summary format and adding my group fields back in.
Bob MooreBob Moore 
Hi all, I'm trying to build a formula field that returns a value based on checkboxes being true or false.

There are 3 checkbox fields total.

If only 1/3 is checked, the formula field should = 33
If 2/3 are checked = 66
If 3/3 are checked = 100

I'm struggling to figure out how to get all the combinations in one formula (nested IF statements?) Is anybody able to help?
Best Answer chosen by Bob Moore
Tony TrinhTony Trinh
FLOOR((IF(Box1__c,1,0) + IF(Box2__c,1,0) + IF(Box3__c,1,0))*100/3)

If you need 33 instead of 33.333, use this.
Hemdène Ben HammoudaHemdène Ben Hammouda 

I'm getting the below error when i try to create a dashboard, the report is saved in a folder that the running user has access to
Also the running user has access to all the fields for the Opportunity Object (that's the report type) and all of the other components of the dashboard are savec in the same folder everything else is working expect this specific component 

We can't show this table because the "Viewing as" person doesn't have access to all the fields.

Dashboard Error

Any ideas please?

Best Answer chosen by Hemdène Ben Hammouda
Hemdène Ben HammoudaHemdène Ben Hammouda
Hi Tommaso,

Now it's working fine : what i had to do is to delete the compenent and re create it again

Best Answer chosen by Jayson ( 
Jeff MayJeff May
Once you have defined your Summary report, you can add Summary fields by dragging the "Add Formula' link from the top of the field selector on the left of the Report Builder page.  This will open a pop up where you can define the Summary field.