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 10030
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.
2
votes
2
answers
961
views
How do I write a formula using a picklist and a date + value from picklist
I need to create a formula that uses the service level from the pick and custom field (last review date) to populate field (Next review date) based on the statement below:
If A, then LAST + 3 month … I tried formula below
IF(ISPICKVAL(PSG_Service_Level__c, "A"),
TEXT(MONTH(Last_Investment_Review__c + 3)) + "/" +
TEXT(DAY(Last_Investment_Review__c)) + "/" +
TEXT(YEAR(Last_Investment_Review__c)), "" …
- 61