2
votes
Accepted
How keep these 2 logics in one IF statement formula?
Calling back to your previous question, the opposite of SBQQ__NetAmount__c <= 7500 is SBQQ__NetAmount__c > 7500. Those two conditions cover every possible number.
So while your formula is ...
- 58.3k
2
votes
Accepted
Need to calculate Elapsed time between 2 Date time fields excluding weekends
Anything beyond the most simple of Date/time calculations are generally best done using Apex instead of formulas.
That said, it does look like there are improvements that you can make here.
Swapping ...
- 58.3k
1
vote
Salesforce - How to compare two Date/Time fields?
This strikes me as an odd way to use the CASE() function. I think the issue here is that you're trying to make a "dynamic formula". Something where the actual formula isn't known until "...
- 58.3k
1
vote
Accepted
Sort list/kanban view by integer formula field
Yes, it is possible to do this. Here is my Account List View sorted by Days Old (a Number formula field):
- 2,285
Only top scored, non community-wiki answers of a minimum length are eligible