Versions Compared

Old Version 13

changes.mady.by.user Jodie Miners

Saved on

compared with

New Version Current

changes.mady.by.user Jodie Miners

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Widget Connector
urlhttps://www.youtube.com/watch?v=pkD4XOVvkts

 


Formula Pages

Other pages in this site about formulas

Filter by label (Content by label)
showLabelsfalse
spacesSF
showSpacefalse
excerpttrue
typepage
excerptTypesimple
cqllabel = "formula" and type = "page" and space = "SF"
labelsformula

Articles about Formulas

Page Properties Report
spacesSF
headingslink
labelformulas
cqllabel = "formulas" and space = "SF"

Example Formulas

The Salesforce help has some nice examples https://help.salesforce.com/HTViewHelpDoc?id=useful_advanced_formulas.htm and date formulas https://help.salesforce.com/HTViewHelpDoc?id=formula_examples_dates.htm

...

IF(AND((ContractExpiry__c) > TODAY()-14,ISPICKVAL(Contractor_Status__c,"Active")),True,False)

State and Country for use with State and Country Picklists

IF(NOT(ISBLANK(BLANKVALUE(TEXT(BillingStateCode) ,TEXT(ShippingStateCode)))),
BLANKVALUE( TEXT(ShippingStateCode) ,TEXT(BillingStateCode)) & IF(BLANKVALUE(TEXT(ShippingCountryCode), TEXT(BillingCountryCode)) = "AU","", ", " & BLANKVALUE(TEXT(ShippingCountryCode), TEXT(BillingCountryCode))),"")

/*IF(NOT(ISBLANK(BLANKVALUE(TEXT(BillingStateCode) ,TEXT(ShippingStateCode)))),
BLANKVALUE( TEXT(BillingStateCode) ,TEXT(ShippingStateCode)) & IF(BLANKVALUE(TEXT(BillingCountryCode), TEXT(ShippingCountryCode)) = "AU","", ", " & BLANKVALUE(TEXT(BillingCountryCode), TEXT(ShippingCountryCode))),"")*/

Warning fields

Requirement for a field to create a warning that a contract if about to expire

...