Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with formula
Search options not deleted
user 87404
A formula is an algorithm that derives its value from other fields, expressions, or values. Formulas can help you automatically calculate the value of a field based on other fields (from Salesforce doc). Formulas can be used in many areas of Salesforce other than just Formula Fields, such as Validation Rules and criteria for Workflow Rules and Approval Processes.
0
votes
1
answer
313
views
Salesforce Comparison Formula
I have some requirement to create a formula that evaluates if Fiscal Year >= Current FY, then returns true.
So our fiscal year starts on July 1 and ends June 30. …
- 15
0
votes
Salesforce Comparison Formula
Never mind, I fixed it:
I mixed up the LEFT & RIGHT functions by taking 3 values from the right, and >=6, when it should have been <=6, which gave me "-22" >= "21" resulting in the wrong false/true ev …
- 15
0
votes
1
answer
613
views
Shorten a Nested If Formula for Fiscal Year
I created a formula with nested if statements. Since the conditions are similar, is there a way to write it elegantly?
Fiscal_Year__c is a picklist field with values such as 20-21, 21-22, 22-23 etc. …
- 15