{"id":2122,"date":"2019-07-05T15:51:57","date_gmt":"2019-07-05T14:51:57","guid":{"rendered":"https:\/\/help.cirrus-shield.com\/docs\/fields\/create-formula-field\/use-the-formula-functions\/"},"modified":"2020-04-27T19:11:42","modified_gmt":"2020-04-27T18:11:42","slug":"use-the-formula-functions","status":"publish","type":"docs","link":"https:\/\/help.cirrus-shield.com\/en\/docs\/fields\/create-formula-field\/use-the-formula-functions\/","title":{"rendered":"Use the Formula Functions"},"content":{"rendered":"\n
Functions<\/strong><\/th>Description<\/strong><\/th><\/tr><\/thead>
IF<\/strong><\/td>Determines if expressions are true or false. Returns a given value if true and another value if false.<\/td><\/tr>
ISNUMBER<\/strong><\/td>Determines if a text value is a number and returns True if it is. Otherwise, it returns False.<\/td><\/tr>
ABS<\/strong><\/td>Calculates the absolute value of a number. The absolute value of a number is the number without its positive or negative sign.<\/td><\/tr>
MAX<\/strong><\/td>Returns the highest number from a list of numbers.<\/td><\/tr>
MIN<\/strong><\/td>Returns the lowest number from a list of numbers.<\/td><\/tr>
NOW<\/strong><\/td>Returns the current date and time in Date\/Time data type.<\/td><\/tr>
TODAY<\/strong><\/td>Returns the current date as a date data type.<\/td><\/tr>
DATEVALUE<\/strong><\/td>Returns a date value for a date\/time.<\/td><\/tr>
DATETIMEVALUE<\/strong><\/td>Returns a year, month, day and time value in the GMT timezone.<\/td><\/tr>
CONTAINS<\/strong><\/td>Compares two arguments of text and returns True if the first argument contains the second argument. If not, returns False.<\/td><\/tr>
STRARTSWITH<\/strong><\/td>Determines the value or text to start with.<\/td><\/tr>
ENDSWITH<\/strong><\/td>Determines the value or text to end with.<\/td><\/tr>
ISPICKVAL<\/strong><\/td>Determines if the value of a picklist field is equal to a text literal you specify.<\/td><\/tr>
INCLUDES<\/strong><\/td>Determines if the value of a picklist field is equal to a text literal you specify.<\/td><\/tr>
HYPERLINK<\/strong><\/td>Creates a link to a URL specified that is linkable from the text specified.<\/td><\/tr>
TEXT<\/strong><\/td>Returns the text value of a literal.
Example: TEXT(picklist) returns the text value of the selected item in the picklist field.<\/td><\/tr>
VALUE<\/strong><\/td>Returns the decimal value of a literal.
Example: VALUE(“3.6”) returns the decimal value 3.6<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"author":1,"featured_media":0,"parent":1830,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"doc_tag":[],"class_list":["post-2122","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs\/2122","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/comments?post=2122"}],"version-history":[{"count":8,"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs\/2122\/revisions"}],"predecessor-version":[{"id":4137,"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs\/2122\/revisions\/4137"}],"up":[{"embeddable":true,"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs\/1830"}],"prev":[{"title":"Use the Formula Operators","link":"https:\/\/help.cirrus-shield.com\/en\/docs\/fields\/create-formula-field\/use-the-formula-operators\/","href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/docs\/2121"}],"wp:attachment":[{"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/media?parent=2122"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/help.cirrus-shield.com\/en\/wp-json\/wp\/v2\/doc_tag?post=2122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}