関数一覧

[Answersで回答する時に使う情報のまとめ](https://qiita.com/Keiji_otsubo/items/9e6e0e946826133eddc7)
[末尾に移動](https://qiita.com/Keiji_otsubo/items/05c918c17a2395b3c17e#%E6%9C%AB%E5%B0%BE)


[Unable to create a formula field that has a rich text area field](https://help.salesforce.com/s/articleView?id=000329422&type=1)

```
INCLUDES(Multi_Picklist_field_name__c , "Pick List Value 1")
```
+ [フロー式に関する考慮事項](https://qiita.com/Keiji_otsubo/items/35975b42607e1485fd73)
+ [Tips for Working with Picklist and Multi-Select Picklist Formula Fields](https://help.salesforce.com/s/articleView?id=sf.tips_for_using_picklist_formula_fields.htm&type=5)
+ [新しいページ　英語のみ](https://help.salesforce.com/s/articleView?id=sf.customize_functions.htm&type=5)


| 関数 | 説明|Picklist |Multi-Select Picklists | Process Bilder |Report|
|:---------------------|:------------|:------------|:------------|:------------|:------------|
|[ABS](https://help.salesforce.com/s/articleView?id=sf.bi_integrate_data_prep_recipe_formula_field_numericFunctions_abs.htm&type=5)||||||
|[ADDMONTHS](https://qiita.com/Keiji_otsubo/items/c050597f7ecb170ff6b0)||||| 例:ADDMONTHS( Start_Date__c , Months__c )|
|[AND](https://help.salesforce.com/s/articleView?id=sf.customize_functions_and1.htm&type=5)||||||
|[BEGINS](https://help.salesforce.com/s/articleView?id=sf.customize_functions_begins.htm&type=5)||||||
|[BLANKVALUE](https://help.salesforce.com/s/articleView?id=sf.customize_functions_blankvalue.htm&type=5)||||| [Calculate number of business days with multiple dates](https://trailhead.salesforce.com/ja/trailblazer-community/feed/0D54S00000Bt5K7SAJ)|
|[BR](https://help.salesforce.com/s/articleView?id=sf.customize_functions_br.htm&type=5)||||||
|[CASE](https://help.salesforce.com/s/articleView?id=sf.customize_functions_case.htm&type=5)||OK|||[Case(数式)のまとめ](https://qiita.com/Keiji_otsubo/items/4d3ce97059a1bf7088d4)|
|[CASESAFEID](https://help.salesforce.com/s/articleView?id=sf.customize_functions_casesafeid.htm&type=5)|Converts a 15-character ID to a case-insensitive18-character ID.式が大きくなるので注意|||||
|[ceil](https://help.salesforce.com/s/articleView?id=sf.bi_integrate_data_prep_recipe_formula_field_numericFunctions_ceil.htm&type=5)||||||
|[CEILING](https://help.salesforce.com/s/articleView?id=sf.customize_functions_ceiling.htm&type=5)|数値を最も近い整数 (負の場合は 0 から遠い方) に切り上げます。|||||
|[CONTAINS](https://qiita.com/Keiji_otsubo/items/8859f3d8c27e8cdbfb62)|CONTAINS(field__c, "text")||OK||OK|
|[CURRENCYRATE](https://help.salesforce.com/s/articleView?id=sf.customize_functions_currencyrate.htm&type=5)|指定された通貨 ISO コードのマスタ通貨に対する換算レートを返します。通貨が無効な場合は 1.0 を返します。|||||
|[DATE](https://help.salesforce.com/s/articleView?id=sf.customize_functions_date.htm&type=5)||||||
|[DATEVALUE](https://help.salesforce.com/s/articleView?id=sf.customize_functions_datevalue.htm&type=5)||||||
|[DATETIMEVALUE](https://help.salesforce.com/s/articleView?id=sf.customize_functions_datetimevalue.htm&type=5)|||||
|[DAY](https://help.salesforce.com/s/articleView?id=sf.customize_functions_day.htm&type=5)||||||
|[DISTANCE](DISTANCE)|2 つの場所の距離をマイル単位またはキロ単位で計算します。|||||
|[EXP](https://help.salesforce.com/s/articleView?id=sf.bi_integrate_data_prep_recipe_formula_field_numericFunctions_exp.htm&type=5)||||||POWER はない|
|[FIND](https://help.salesforce.com/s/articleView?id=sf.customize_functions_find.htm&type=5)||||||
|[FLOOR](https://help.salesforce.com/s/articleView?id=sf.bi_integrate_data_prep_recipe_formula_field_numericFunctions_floor.htm&type=5)||||||
|[GEOLOCATION](https://help.salesforce.com/s/articleView?id=sf.customize_functions_geolocation.htm&type=5)||||||
|[GETRECORDIDS](https://qiita.com/Keiji_otsubo/items/e92c04e3cdfda2a19cf8)||||||
|[GETSESSIONID](https://help.salesforce.com/s/articleView?id=sf.customize_functions_getsessionid.htm&type=5)|ユーザのセッション ID を返します。|||||
|[HOUR](https://help.salesforce.com/s/articleView?id=sf.customize_functions_hour.htm&type=5)||||||
|[HTMLENCODE](https://help.salesforce.com/s/articleView?id=sf.customize_functions_htmlencode.htm&type=5)||||||
|[HYPERLINK](https://help.salesforce.com/s/articleView?id=sf.customize_functions_hyperlink.htm&type=5)||||||
| 関数 | 説明|Picklist |Multi-Select Picklists | Process Bilder |Report|
|[IF](https://help.salesforce.com/s/articleView?id=sf.customize_functions_if.htm&type=5)||||||
|[IMAGE](https://help.salesforce.com/s/articleView?id=sf.customize_functions_image.htm&type=5)||||||
|[IMAGEPROXYURL](https://help.salesforce.com/s/articleView?id=sf.customize_functions_imageproxyurl.htm&type=5)|外部画像を安全に取得し、防止します・ユーザー資格情報の不正な要求。|||||
|[INCLUDE](https://qiita.com/Keiji_otsubo/items/8859f3d8c27e8cdbfb62)|||||S コントロール スニペットからコンテンツを返します。この関数を使用して、多くの S コントロールで共通コードを再利用します。|
|[**INCLUDES**](https://help.salesforce.com/s/articleView?id=sf.customize_functions_includes.htm&type=5)|||OK|||
|[**ISBLANK**](https://qiita.com/Keiji_otsubo/items/655916402fc4f40f3dc1)|||OK||||
|[**ISCHANGED**](https://qiita.com/Keiji_otsubo/items/99de13b6b72314720497)|To use ISCHANGED in a Workflow Rule, use the "when the following formula evaluates to true" option.||OK|||
|[ISCLONE](https://help.salesforce.com/s/articleView?id=sf.customize_functions_isclone.htm&type=5)||||||
|[ISNEW](https://qiita.com/Keiji_otsubo/items/953ecb294fe546335d5b)||||||
|[isNullでのエラー](https://qiita.com/Keiji_otsubo/items/e079155381442ea645c3)|非推奨||OK|||
|[ISNUMBER](https://help.salesforce.com/s/articleView?id=sf.customize_functions_isnumber.htm&type=5)||||||
|[**ISPICKVAL**](https://help.salesforce.com/s/articleView?id=sf.customize_functions_ispickval.htm&type=5)||OK||||
|[JSENCODE](https://help.salesforce.com/s/articleView?id=sf.customize_functions_jsencode.htm&type=5&language=en_US)||||||バックスラッシュ (\) などのエスケープ文字を、アポストロフィ (') などの安全でない JavaScript 文字の前に挿入することにより、JavaScript で使用するテキストおよび差し込み項目の値をエンコードします。|
|[JSINHTMLENCODE](https://help.salesforce.com/s/articleView?id=sf.customize_functions_jsinhtmlencode.htm&type=5)||||||
|[JUNCTIONIDLIST](https://help.salesforce.com/s/articleView?id=sf.customize_functions_junctionidlist.htm&type=5)||||||
|[LEFT](https://help.salesforce.com/s/articleView?id=sf.customize_functions_left.htm&type=5)||||||
|[LEN](https://help.salesforce.com/s/articleView?id=sf.customize_functions_len.htm&type=5)||||||
|[LINKTO](https://help.salesforce.com/s/articleView?id=sf.customize_functions_linkto.htm&type=5)|リンク (href およびアンカータグ) の形式で、カスタムSコントロールまたは Salesforce ページへの相対 URL を返します。|||||
|[LN](https://help.salesforce.com/s/articleView?id=sf.customize_functions_ln.htm&type=5)||||||
|[LOG](https://help.salesforce.com/s/articleView?id=sf.customize_functions_log.htm&type=5)||||||
|[LOWER](https://help.salesforce.com/s/articleView?id=sf.customize_functions_lower.htm&type=5)||||||
|[**LPAD**](https://help.salesforce.com/s/articleView?id=sf.customize_functions_lpad.htm&type=5)|||||[使用例](https://qiita.com/Keiji_otsubo/items/8816d26affe5742108e1)|
|[MAX](https://help.salesforce.com/s/articleView?id=sf.customize_functions_max.htm&type=5)||||||
|[MCEILING](https://help.salesforce.com/s/articleView?id=sf.customize_functions_mceiling.htm&type=5)|数値を最も近い整数 (負の場合は 0 に近い方) に切り上げます。|||||
|[MFLOOR](https://help.salesforce.com/s/articleView?id=sf.customize_functions_mfloor.htm&type=5)|数値を最も近い整数 (負の場合は 0 から遠い方) に切り捨てます。|||||
|[MID](https://help.salesforce.com/s/articleView?id=sf.customize_functions_mid.htm&type=5)||||||
|[MILLISECOND](https://help.salesforce.com/s/articleView?id=sf.customize_functions_millisecond.htm&type=5)|ミリ秒値を 0 ～ 999 の数値形式で返します。|||||
|[MIN](https://help.salesforce.com/s/articleView?id=sf.customize_functions_min.htm&type=5)||||||
|[MINUTE](https://help.salesforce.com/s/articleView?id=sf.customize_functions_minute.htm&type=5)||||||
|[MOD](https://help.salesforce.com/s/articleView?id=sf.customize_functions_mod.htm&type=5)||||||
|[MONTH](https://help.salesforce.com/s/articleView?id=sf.customize_functions_month.htm&type=5)||||||
|[NOT](https://help.salesforce.com/s/articleView?id=sf.customize_functions_not.htm&type=5)||||||
|[NOW](https://help.salesforce.com/s/articleView?id=sf.customize_functions_now.htm&type=5)||||||
|[NULLVALUE](https://help.salesforce.com/s/articleView?id=sf.customize_functions_nullvalue.htm&type=5)|非推奨|||||
|[OR](https://help.salesforce.com/s/articleView?id=sf.customize_functions_or_0.htm&type=5)||||||
|[PARENTGROUPVAL](https://help.salesforce.com/s/articleView?id=sf.customize_functions_parentgroupval.htm&type=5)||||||
|[PICKLISTCOUNT](https://qiita.com/Keiji_otsubo/items/f47c150db9a24989eb80)|||||
|[PREDICT](https://help.salesforce.com/s/articleView?id=sf.customize_functions_predict.htm&type=5)||||||
|[PREVGROUPVAL](https://help.salesforce.com/s/articleView?id=sf.customize_functions_prevgroupval.htm&type=5)||||||
|[**PRIORVALUE**](https://qiita.com/Keiji_otsubo/items/d055e90ee11e653d9d49)|||OK|||
|[**REGEX**](https://qiita.com/Keiji_otsubo/items/f153991a269e69e9c2de)||||||
|[REQUIRESCRIPT](https://help.salesforce.com/s/articleView?id=sf.customize_functions_requirescript.htm&type=5)||||||
|[REVERSE](https://help.salesforce.com/s/articleView?id=sf.customize_functions_reverse.htm&type=5)||||||
|[RIGHT](https://help.salesforce.com/s/articleView?id=sf.customize_functions_right.htm&type=5)||||||
|[ROUND](https://help.salesforce.com/s/articleView?id=sf.customize_functions_round.htm&type=5)||||||
|[**RPAD**](https://help.salesforce.com/s/articleView?id=sf.customize_functions_rpad.htm&type=5)||||||
|[SECOND](https://help.salesforce.com/s/articleView?id=sf.customize_functions_second.htm&type=5)||||||
|[SQRT](https://help.salesforce.com/s/articleView?id=sf.customize_functions_sqrt.htm&type=5)||||||
|[**SUBSTITUTE**](https://qiita.com/Keiji_otsubo/items/60137099b3e345ca57b9)||||||
|[TEXT](https://help.salesforce.com/s/articleView?id=sf.customize_functions_text.htm&type=5)||OK|||||
|[TIMENOW](https://help.salesforce.com/s/articleView?id=sf.customize_functions_timenow.htm&type=5)||||||
|[**TIMEVALUE**](https://help.salesforce.com/s/articleView?id=sf.customize_functions_timevalue.htm&type=5)|||||[バグ](https://qiita.com/Keiji_otsubo/items/973548478f103cd0d64d)|
|[TODAY](https://help.salesforce.com/s/articleView?id=sf.customize_functions_today.htm&type=5)|日付型|||||
|[TRIM](https://help.salesforce.com/s/articleView?id=sf.customize_functions_trim.htm&type=5)||||||
|[UPPER](https://help.salesforce.com/s/articleView?id=sf.customize_functions_upper.htm&type=5)||||||
|[URLENCODE](https://help.salesforce.com/s/articleView?id=sf.customize_functions_urlencode.htm&type=5)||||||
|[URLFOR](https://help.salesforce.com/s/articleView?id=sf.customize_functions_urlfor.htm&type=5)||||||
|[VALUE](https://help.salesforce.com/s/articleView?id=sf.customize_functions_value.htm&type=5)||||||
|[VLOOKUP](https://qiita.com/Keiji_otsubo/items/163525ef36ea1f78000a)||||||
|[WEEKDAY](https://qiita.com/Keiji_otsubo/items/4480c1f7208cc9bab6ea)||||||
|[YEAR](https://help.salesforce.com/s/articleView?id=sf.customize_functions_year.htm&type=5)||||||
| 関数 | 説明|Picklist |Multi-Select Picklists | Process Bilder |Report|

# 末尾

# To use ISCHANGED in a Workflow Rule, use the "when the following formula evaluates to true" option.

[Error: Function ISCHANGED may not be used in this type of formula](https://salesforce.stackexchange.com/questions/163067/error-function-ischanged-may-not-be-used-in-this-type-of-formula)