{"id":6492,"date":"2020-03-31T20:41:20","date_gmt":"2020-03-31T18:41:20","guid":{"rendered":"https:\/\/lacolmenatecnologica.com\/tables-in-notion-formulas-and-functions\/"},"modified":"2026-09-02T19:37:23","modified_gmt":"2026-09-02T17:37:23","slug":"tables-in-notion-formulas-and-functions","status":"publish","type":"post","link":"https:\/\/lacolmenatecnologica.com\/en\/tables-in-notion-formulas-and-functions\/","title":{"rendered":"Tables in Notion: Formulas and Functions"},"content":{"rendered":"<p>[mepr-show rules=&#8221;7898&#8243; unauth=&#8221;message&#8221;]<\/p>\n\n<figure class=\"wp-block-embed is-type-video is-provider-vimeo wp-block-embed-vimeo wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/vimeo.com\/401908864\n<\/div><figcaption>Click the PLAY button to watch the video<\/figcaption><\/figure>\n<p>[\/mepr-show]<\/p>\n\n<h1 class=\"wp-block-heading\" id=\"0-f%C3%B3rmulas-y-funciones-en-notion\">Formulas and Functions in Notion<\/h1>\n\n<p class=\"wp-block-paragraph\">Below we will break down technical details and examples for each Notion function, operator, and constant, as well as the patterns used to format dates using the <code><span class=\"has-inline-color has-vivid-red-color\">formatDate()<\/span><\/code> function.<\/p>\n\n<h2 class=\"wp-block-heading\" id=\"1-f%C3%B3rmulas\">Formulas<\/h2>\n\n<p class=\"wp-block-paragraph\">Formulas are calculation expressions that we can use in <em>Formula<\/em> type properties, which can be composed of operators, functions, numeric and text values, and property references. Property references give us the ability to perform different and automatic calculations for each of the records in the table or database by entering a single formula. <\/p>\n\n<figure class=\"wp-block-image size-large\"><img alt=\"Notion Formulas y Funciones\" loading=\"lazy\" decoding=\"async\" width=\"1238\" height=\"589\" src=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-1.jpg\" alt=\"\" class=\"wp-image-5662\" srcset=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-1.jpg 1238w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-1-500x238.jpg 500w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-1-1024x487.jpg 1024w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-1-768x365.jpg 768w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-1-600x285.jpg 600w\" sizes=\"auto, (max-width: 1238px) 100vw, 1238px\" \/><\/figure>\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>All these functions, operators, and constants can only be used within a Notion table environment and more specifically within a Formula type property.<\/p><\/blockquote>\n\n<h2 class=\"wp-block-heading\" id=\"2-funciones\">Functions<\/h2>\n\n<p class=\"wp-block-paragraph\">Functions help us perform calculations and operations, returning a result. There are many functions and they can be classified by the type of data they return as a result. We can tell what type they are by looking at the icon that precedes the function in the list.  <\/p>\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img alt=\"Notion tipo de funciones\" loading=\"lazy\" decoding=\"async\" width=\"697\" height=\"430\" src=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-tipo-de-funciones.jpg\" alt=\"\" class=\"wp-image-5667\" srcset=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-tipo-de-funciones.jpg 697w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-tipo-de-funciones-500x308.jpg 500w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-tipo-de-funciones-600x370.jpg 600w\" sizes=\"auto, (max-width: 697px) 100vw, 697px\" \/><\/figure><\/div>\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>The <strong>boolean<\/strong> type returns a logical result, which can have two possible values: <span class=\"has-inline-color has-vivid-red-color\">True<\/span> or <span class=\"has-inline-color has-vivid-red-color\">False<\/span>. Notion represents this value as a checkbox\u2014if it&#8217;s checked it&#8217;s true, and if not it&#8217;s false. <\/p><\/blockquote>\n\n<h3 class=\"wp-block-heading\" id=\"3-caracter%C3%ADsticas-de-las-funciones\">Function Characteristics<\/h3>\n\n<ul class=\"wp-block-list\"><li>All functions have this syntactic structure: <code><span class=\"has-inline-color has-vivid-red-color\">nombre(par\u00e1metro, par\u00e1metro)<\/span><\/code>. Immediately after the function name, a parenthesis always opens, without leaving any space between the function name and the parenthesis. Between the opening and closing parenthesis we place the parameters, separated by commas, example: <code><span class=\"has-inline-color has-vivid-red-color\">equal(2, 4)<\/span><\/code>.  <\/li><li>There are functions that don&#8217;t need parameters, example: <code><span class=\"has-inline-color has-vivid-red-color\">now()<\/span><\/code>.<\/li><li>We can include the value of a property as a parameter within a function, example: <code><span class=\"has-inline-color has-vivid-red-color\">day(prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"fecha de alta\"<\/span><span class=\"has-inline-color has-vivid-red-color\">))<\/span><\/code>. As we see in the example, <code><span class=\"has-inline-color has-vivid-red-color\">prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"fecha de alta\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/code> is how we invoke the property. <\/li><li>Text type parameters always go in quotes, example: <code><span class=\"has-inline-color has-vivid-red-color\">length(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Hello world\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/code>. If the text value is within a property, we don&#8217;t need to add additional quotes, example: <code><span class=\"has-inline-color has-vivid-red-color\">length(prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"nombre\"<\/span><span class=\"has-inline-color has-vivid-red-color\">))<\/span><\/code>. <\/li><li>All functions return a result that can be a <em>number<\/em>, <em>text<\/em>, <em>date<\/em> or time, or a <em>boolean<\/em>.<\/li><li>Functions can be nested within each other, example: <code><span class=\"has-inline-color has-vivid-red-color\">formatDate(now(), <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"DD\/MM\/YYYY\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/code>. In the example we nest <code><span class=\"has-inline-color has-vivid-red-color\">now()<\/span><\/code> inside <code><span class=\"has-inline-color has-vivid-red-color\">formatDate()<\/span><\/code>.<\/li><li>We can perform mathematical operations with the results returned by functions within the same formula, example: <code><span class=\"has-inline-color has-vivid-red-color\">round(prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"total\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)) + 10<\/span><\/code><\/li><\/ul>\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><strong>Parameters and arguments:<\/strong> these concepts can create confusion because they seem to be the same but they&#8217;re not. For example, when we state the function <code><span class=\"has-inline-color has-vivid-red-color\">subtract(n\u00famero, n\u00famero)<\/span><\/code>, we can say this function needs two numeric parameters; however, when we&#8217;re passing data to the function, these are called arguments, example: <code><span class=\"has-inline-color has-vivid-red-color\">subtract(5, 3)<\/span><\/code>. In this case, 5 and 3 are the arguments we pass to the function&#8217;s parameters. We could say that a parameter is the container and the argument is the content.  <\/p><\/blockquote>\n\n<h2 class=\"wp-block-heading\" id=\"4-funciones-l%C3%B3gicas-de-notion\">Notion Logical Functions<\/h2>\n\n<p class=\"wp-block-paragraph\">Logical functions evaluate boolean logical tests. Below you can see a table with the logical operators we can use to perform these comparisons. <\/p>\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Operator<\/th><th>Description<\/th><th>Example<\/th><\/tr><\/thead><tbody><tr><td><code><span class=\"has-inline-color has-vivid-red-color\">==<\/span><\/code><\/td><td>Equal<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">2 == 2<\/span><\/code>  \u2192 <code><code><span class=\"has-inline-color has-vivid-red-color\">verdadero<\/span><\/code><\/code> | <code><span class=\"has-inline-color has-vivid-red-color\">\"Coche\" == \"Casa\"<\/span><\/code> \u2192  <code><code><span class=\"has-inline-color has-vivid-red-color\">falso<\/span><\/code><\/code><\/td><\/tr><tr><td><code><span class=\"has-inline-color has-vivid-red-color\">!=<\/span><\/code><\/td><td>Not equal or unequal<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">2 != 2<\/span><\/code>  \u2192 <code><span class=\"has-inline-color has-vivid-red-color\">falso<\/span><\/code> | <code><span class=\"has-inline-color has-vivid-red-color\">\"Coche\" != \"Casa\"<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">verdadero<\/span><\/code><\/td><\/tr><tr><td><code><span class=\"has-inline-color has-vivid-red-color\">&gt;<\/span><\/code><\/td><td>Greater than<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">2 &gt; 2<\/span><\/code>  \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">falso<\/span><\/code> <\/td><\/tr><tr><td><code><span class=\"has-inline-color has-vivid-red-color\">&lt;<\/span><\/code><\/td><td>Less than<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">2 &lt; 3<\/span><\/code>  \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">verdadero<\/span><\/code><\/td><\/tr><tr><td><code><span class=\"has-inline-color has-vivid-red-color\">&lt;=<\/span><\/code><\/td><td>Less than or equal to<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">2 &gt;= 3<\/span><\/code>  \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">falso<\/span><\/code><\/td><\/tr><tr><td><code><span class=\"has-inline-color has-vivid-red-color\">&gt;=<\/span><\/code><\/td><td>Greater than or equal to<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">2 &lt;= 2<\/span><\/code>  \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">verdadero<\/span><\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n<h3 class=\"wp-block-heading\" id=\"5-a-tener-en-cuenta\">Things to Keep in Mind<\/h3>\n\n<ul class=\"wp-block-list\"><li>When comparing text strings, they must be in quotes, example: <code><span class=\"has-inline-color has-vivid-red-color\">\"Coche\" != \"Casa\"<\/span><\/code>.<\/li><li>You cannot compare a number with a text string in a logical test since they are different types, but we can use the <code><span class=\"has-inline-color has-vivid-red-color\">format()<\/span><\/code> function (converts a number to a text string) or <code><span class=\"has-inline-color has-vivid-red-color\">toNumber()<\/span><\/code> (converts a text string to a number) to convert them and be able to compare them. The <code><span class=\"has-inline-color has-vivid-red-color\">toNumber()<\/span><\/code> function can also convert a boolean to a number: if it&#8217;s <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> (true) it will convert it to <code><span class=\"has-inline-color has-vivid-red-color\">1<\/span><\/code>, and if it&#8217;s <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code> (false) to <code><span class=\"has-inline-color has-vivid-red-color\">0<\/span><\/code>. <\/li><li>We can use table properties in the logical test, example: <code><span class=\"has-inline-color has-vivid-red-color\">prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"nombre\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)==\"Antonio\"<\/span><\/code> or <code><span class=\"has-inline-color has-vivid-red-color\">prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"total\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)&gt;1000<\/span><\/code>. Or we can use nested functions to convert the values to the type we need to compare them, example: <code><span class=\"has-inline-color has-vivid-red-color\">toNumber(prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"valor1\"<\/span><span class=\"has-inline-color has-vivid-red-color\">))&gt;prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"valor2\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/code>. <\/li><\/ul>\n\n<hr class=\"wp-block-separator has-text-color has-background has-very-light-gray-background-color has-very-light-gray-color is-style-wide\" \/>\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"6-and-prueba-l%C3%B3gica-prueba-l%C3%B3gica-\"><span class=\"has-inline-color has-vivid-red-color\">and(<\/span>logical test<span class=\"has-inline-color has-vivid-red-color\">,<\/span> logical test<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Checks whether the values returned from two logical tests are <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> or not. Returns a boolean result. Applied to a property, this shows us a checkbox that, if the result is <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> (true), displays this checkbox checked and otherwise unchecked. This function will return <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> if both comparison expressions are true and will return <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code> if one or both are false.   <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">and( 2 == 2, 2 == 3 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The first comparison expression, must evaluate to a boolean value.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> The second comparison expression, must evaluate to a boolean value.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>This function allows the use of regular expressions; if you want to learn how to use them, <a href=\"https:\/\/lacolmenatecnologica.com\/cursos\/curso-de-notion\/lecciones\/6-tablas-en-notion-ii-formulas-y-funciones\/temas\/expresiones-regulares-en-notion\/\">click here<\/a>.<\/p><\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img alt=\"Notion Funcion and()\" loading=\"lazy\" decoding=\"async\" width=\"519\" height=\"207\" src=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-3.jpg\" alt=\"\" class=\"wp-image-5663\" srcset=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-3.jpg 519w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-3-500x199.jpg 500w\" sizes=\"auto, (max-width: 519px) 100vw, 519px\" \/><figcaption>The formula is included in the \u01a9 Formula property<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 2:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">and(prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Prop 1\"<\/span><span class=\"has-inline-color has-vivid-red-color\">), prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Prop 2\"<\/span><span class=\"has-inline-color has-vivid-red-color\">) &gt;= 10)<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> In the first argument, no comparison expression is needed since the argument itself is boolean because the &#8220;Prop 1&#8221; property is a Checkbox type, so the argument itself provides us with a <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> or a <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> The second argument evaluates whether the value of the &#8220;Prop 2&#8221; property in each row is greater than or equal to 10.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"7-empty-valor-\"><span class=\"has-inline-color has-vivid-red-color\">empty(<\/span>value<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Checks whether the argument is empty; if it&#8217;s empty it returns <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code>, if it&#8217;s full <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code>. Returns a boolean.  <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">empty( <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Mundo\"<\/span><span class=\"has-inline-color has-vivid-red-color\"> )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 2:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">empty( <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"\"<\/span><span class=\"has-inline-color has-vivid-red-color\"> )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument:<\/strong> The expression to check, which can evaluate any type of value, for example, a number, text string, or date.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img alt=\"Notion Funcion empty()\" loading=\"lazy\" decoding=\"async\" width=\"437\" height=\"196\" src=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-4.jpg\" alt=\"\" class=\"wp-image-5664\"\/><figcaption>The formula is included in the \u01a9 Formula property<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 3:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">empty(prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Valor\"<\/span><span class=\"has-inline-color has-vivid-red-color\">))<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument:<\/strong> Evaluates whether the value of the &#8220;Value&#8221; property in each row is empty or not. If the property is empty it provides us with a <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code>, and when it&#8217;s not <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code>. <\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"8-equal-valor-valor-\"><span class=\"has-inline-color has-vivid-red-color\">equal(<\/span>value<span class=\"has-inline-color has-vivid-red-color\">,<\/span> value<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Checks whether the values returned from two expressions are equal. Returns a <code><span class=\"has-inline-color has-vivid-red-color\">boleano<\/span><\/code>. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">equal( 2, 3 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 2:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">equal( <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"rojo\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"azul\"<\/span><span class=\"has-inline-color has-vivid-red-color\"> )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 3:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">equal(3 <\/span><span style=\"color:#a57e4f\" class=\"has-inline-color\">*<\/span><span class=\"has-inline-color has-vivid-red-color\"> 5, 15 ) <\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 4:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">equal( false, <\/span><span style=\"color:#a57e4f\" class=\"has-inline-color\">not<\/span><span class=\"has-inline-color has-vivid-red-color\"> true ) <\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Equivalent operator:<\/strong> <code><span class=\"has-inline-color has-vivid-red-color\">[expresi\u00f3n] == [expresi\u00f3n]<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The expression to check, which can evaluate any type of value, for example, a number, text string, date, or boolean.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> The expression to check, which can evaluate any type of value, for example, a number, text string, date, or boolean.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img alt=\"Notion Funcion equal()\" loading=\"lazy\" decoding=\"async\" width=\"511\" height=\"201\" src=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-5.jpg\" alt=\"\" class=\"wp-image-5665\" srcset=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-5.jpg 511w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-5-500x197.jpg 500w\" sizes=\"auto, (max-width: 511px) 100vw, 511px\" \/><figcaption>The formula is included in the \u01a9 Formula property<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">equal(prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Valor 1\"<\/span><span class=\"has-inline-color has-vivid-red-color\">), prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Valor 2\"<\/span><span class=\"has-inline-color has-vivid-red-color\">))<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Arguments:<\/strong> Evaluates whether the value of the &#8220;Value 1&#8221; and &#8220;Value 2&#8221; properties are equal. If both properties are equal it provides us with a <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code>, and when they&#8217;re not <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code>. <\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"9-if-prueba-l%C3%B3gica-valor-valor-\"><span class=\"has-inline-color has-vivid-red-color\">if(<\/span>logical test<span class=\"has-inline-color has-vivid-red-color\">,<\/span> value<span class=\"has-inline-color has-vivid-red-color\">,<\/span> value<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The <span class=\"has-inline-color has-vivid-red-color\">if()<\/span> function allows you to perform one action if a condition is met, or another action if the condition is not met. By nesting <span class=\"has-inline-color has-vivid-red-color\">if()<\/span> functions (placing them inside each other), you can specify actions for numerous conditions. This function needs three parameters:  <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Logical test, which evaluates to <code><span class=\"has-inline-color has-vivid-red-color\">verdadero<\/span><\/code> or <code><span class=\"has-inline-color has-vivid-red-color\">falso<\/span><\/code>.<\/li><li>Value or operation to return if the operation is <code><span class=\"has-inline-color has-vivid-red-color\">verdadero<\/span><\/code>.<\/li><li>Value or operation to return if the operation is <code><span class=\"has-inline-color has-vivid-red-color\">falso<\/span><\/code>.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img alt=\"Notion funcion if()\" loading=\"lazy\" decoding=\"async\" width=\"530\" height=\"197\" src=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-if.jpg\" alt=\"\" class=\"wp-image-5666\" srcset=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-if.jpg 530w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-if-500x186.jpg 500w\" sizes=\"auto, (max-width: 530px) 100vw, 530px\" \/><figcaption>The formula is included in the \u01a9 Formula property<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">if(prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Valor 1\"<\/span><span class=\"has-inline-color has-vivid-red-color\">) &gt; prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Valor 2\"<\/span><span class=\"has-inline-color has-vivid-red-color\">), <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Es mayor\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Es menor o igual\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> Evaluates whether the value of the &#8220;Value 1&#8221; property is greater than the &#8220;Value 2&#8221; property. Only if &#8220;Value 1&#8221; is greater than &#8220;Value 2&#8221; will the result of the logical test be <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> (True). <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> If the logical test results in <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code>, the result to display will be &#8220;It is greater&#8221;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 3:<\/strong> If the logical test results in <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code>, the result to display will be &#8220;It is less than or equal to&#8221;.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Since this nested formula is a bit more complex, let&#8217;s look at these examples in a new explanatory video.<\/p><\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"536\" height=\"195\" src=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-if-anidada.jpg\" alt=\"Notion nested if() function\" class=\"wp-image-5668\" srcset=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-if-anidada.jpg 536w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/formulars-funciones-notion-if-anidada-500x182.jpg 500w\" sizes=\"auto, (max-width: 536px) 100vw, 536px\" \/><figcaption>The formula is included in the \u01a9 Formula property<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 2:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">if(prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Valor 1\"<\/span><span class=\"has-inline-color has-vivid-red-color\">) &gt; prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Valor 2\"<\/span><span class=\"has-inline-color has-vivid-red-color\">), <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Es mayor\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, if(prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Valor 1\"<\/span><span class=\"has-inline-color has-vivid-red-color\">) &lt; prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Valor 2\"<\/span><span class=\"has-inline-color has-vivid-red-color\">), <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Es menor\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Es igual\"<\/span><span class=\"has-inline-color has-vivid-red-color\">))<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> Evaluates whether the value of the &#8220;Value 1&#8221; property is greater than the &#8220;Value 2&#8221; property. Only if &#8220;Value 1&#8221; is greater than &#8220;Value 2&#8221; will the result of the logical test be <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> (True). <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> If the logical test results in <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code>, the result to display will be &#8220;It is greater&#8221;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 3:<\/strong> If the logical test results in <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code>, as the third argument we include a new nested <code><span class=\"has-inline-color has-vivid-red-color\">if(prop(\"Valor 1\") &lt; prop(\"Valor 2\"), \"Es menor\", \"Es igual\")<\/span><\/code>; this if has three parameters in turn.<\/p>\n<\/div>\n<\/div>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-vimeo wp-block-embed-vimeo wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/vimeo.com\/444959749\n<\/div><figcaption>Click the PLAY button to watch the video<\/figcaption><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>This function allows the use of regular expressions; if you want to learn how to use them, <a href=\"https:\/\/lacolmenatecnologica.com\/cursos\/curso-de-notion\/lecciones\/6-tablas-en-notion-ii-formulas-y-funciones\/temas\/expresiones-regulares-en-notion\/\">click here<\/a>.<\/p><\/blockquote>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"10-larger-valor-valor-\"><span class=\"has-inline-color has-vivid-red-color\">larger(<\/span>value<span class=\"has-inline-color has-vivid-red-color\">,<\/span> value<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Returns <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> (true) if the first argument is larger than the second and <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code> (false) otherwise. We can evaluate any type of value: text, numbers, dates, or booleans. If the values are equal it would return <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code>. Both parameters must be of the same type (number, text, &#8230;). Returns a boolean.    <\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"590\" height=\"196\" src=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-larger-2.jpg\" alt=\"Notion larger() function\" class=\"wp-image-5670\" srcset=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-larger-2.jpg 590w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-larger-2-500x166.jpg 500w\" sizes=\"auto, (max-width: 590px) 100vw, 590px\" \/><figcaption>The formula is included in the \u01a9 Formula property<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">larger(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Ac\"<\/span><span class=\"has-inline-color has-vivid-red-color\">,<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Ab\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code><br\/><em>Example 2:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">larger(2,3)<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code><br\/>Example 3: <code><span class=\"has-inline-color has-vivid-red-color\">larger(prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Fecha 1\"<\/span><span class=\"has-inline-color has-vivid-red-color\">),prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Fecha 2\"<\/span><span class=\"has-inline-color has-vivid-red-color\">))<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code><br\/><em>Example 4:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">larger(true, false)<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The first expression, which can evaluate any type of value, for example, a number, text, date, or boolean.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> The expression against which to compare the first. Its value type must match the value type of the first expression. <\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"558\" height=\"196\" src=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-larger.jpg\" alt=\"Notion larger() function\" class=\"wp-image-5669\" srcset=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-larger.jpg 558w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-larger-500x176.jpg 500w\" sizes=\"auto, (max-width: 558px) 100vw, 558px\" \/><figcaption>The formula is included in the \u01a9 Formula property<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>How are texts evaluated with larger()?<\/strong>  first evaluates the leftmost letter of each argument; in example 1, since the first letter is &#8220;A&#8221; in both arguments, it moves on to evaluate the second letter\u2014in this case the &#8220;c&#8221; of the first argument is greater than the &#8220;b&#8221; of the second argument because letters have the value of their order in the alphabet, and in this case &#8220;c&#8221; is in the third position and therefore is greater than the &#8220;b&#8221; of the second argument. Any lowercase letter is greater than any uppercase letter. <br\/><br\/><strong>And dates?<\/strong>  the most recent date is always the largest.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Booleans<\/strong>: if it&#8217;s <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> it has value <code><span class=\"has-inline-color has-vivid-red-color\">1<\/span><\/code>, and if it&#8217;s <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code> it has value <code><span class=\"has-inline-color has-vivid-red-color\">0<\/span><\/code>. Therefore the value <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> is always greater than <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code>. <\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"11-largereq-valor-valor-\"><span class=\"has-inline-color has-vivid-red-color\">largerEq(<\/span>value<span class=\"has-inline-color has-vivid-red-color\">,<\/span> value<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">It&#8217;s the same as the previous one with the difference that this function also returns <code>true<\/code> if the arguments are equal. Returns <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> (true) if the first argument is larger than or equal to the second and <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code> (false) if it&#8217;s smaller. We can evaluate any type of value: text, numbers, dates, or booleans. Both parameters must be of the same type (number, text, &#8230;). Returns a boolean.    <\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"590\" height=\"197\" src=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-largereq.jpg\" alt=\"Notion largerEq() function\" class=\"wp-image-5671\" srcset=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-largereq.jpg 590w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-largereq-500x167.jpg 500w\" sizes=\"auto, (max-width: 590px) 100vw, 590px\" \/><figcaption>The formula is included in the \u01a9 Formula property<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">largerEq(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Ac\"<\/span><span class=\"has-inline-color has-vivid-red-color\">,<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Ab\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code><br\/><em>Example 2:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">largerEq(2,2)<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code><br\/>Example 3: <code><span class=\"has-inline-color has-vivid-red-color\">largerEq(prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"fecha 1\"<\/span><span class=\"has-inline-color has-vivid-red-color\">),prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"fecha 2\"<\/span><span class=\"has-inline-color has-vivid-red-color\">))<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code><br\/><em>Example 4:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">largerEq(true, false)<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The first expression, which can evaluate any type of value, for example, a number, text, date, or boolean.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> The expression against which to compare the first. Its value type must match the value type of the first expression. <\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"597\" height=\"195\" src=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-largereq-2.jpg\" alt=\"Notion largerEq() function\" class=\"wp-image-5672\" srcset=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-largereq-2.jpg 597w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-largereq-2-500x163.jpg 500w\" sizes=\"auto, (max-width: 597px) 100vw, 597px\" \/><figcaption>The formula is included in the \u01a9 Formula property<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>How are texts evaluated with larger()?<\/strong>  first evaluates the leftmost letter of each argument; in example 1, since the first letter is &#8220;A&#8221; in both arguments, it moves on to evaluate the second letter\u2014in this case the &#8220;c&#8221; of the first argument is greater than the &#8220;b&#8221; of the second argument because letters have the value of their order in the alphabet, and in this case &#8220;c&#8221; is in the third position and therefore is greater than the &#8220;b&#8221; of the second argument. Any lowercase letter is greater than any uppercase letter. <br\/><br\/><strong>And dates?<\/strong>  the most recent date is always the largest.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Booleans<\/strong>: if it&#8217;s <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> it has value <code><span class=\"has-inline-color has-vivid-red-color\">1<\/span><\/code>, and if it&#8217;s <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code> it has value <code><span class=\"has-inline-color has-vivid-red-color\">0<\/span><\/code>. Therefore the value <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> is always greater than <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code>. <\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"12-not-prueba-l%C3%B3gica-\"><span class=\"has-inline-color has-vivid-red-color\">not(<\/span>logical test<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Checks whether the logical test returns <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code>. If the logical test is <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code> it returns <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> and vice versa. Returns a boolean.  <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">not(2 == 3)<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 2:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">not(prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Pa\u00eds 1\"<\/span><span class=\"has-inline-color has-vivid-red-color\">) == prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Pa\u00eds 2\"<\/span><span class=\"has-inline-color has-vivid-red-color\">))<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 3:<\/em> <code><span style=\"color:#a57e4f\" class=\"has-inline-color\">not<\/span><span class=\"has-inline-color has-vivid-red-color\"> prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Pa\u00eds 1\"<\/span><span class=\"has-inline-color has-vivid-red-color\">) == prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Pa\u00eds 2\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/code><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Example 3 performs the same function as Example 2; when we enter the expression in Notion as we see in Example 2, once we press the Done button it changes it to how we see it in Example 3.<\/p><\/blockquote>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The logical test evaluates a boolean. In this case it evaluates whether <code><span class=\"has-inline-color has-vivid-red-color\">2 == 3<\/span><\/code>; the result is <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code> (false). The function returns the opposite boolean to the result of the logical test: <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code>.  <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"491\" height=\"195\" src=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-not.jpg\" alt=\"Notion not() function\" class=\"wp-image-5673\"\/><figcaption>The formula is included in the \u01a9 Formula property<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 4:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">if (<\/span><span style=\"color:#a57e4f\" class=\"has-inline-color\">not<\/span><span class=\"has-inline-color has-vivid-red-color\"> prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Finalizado\"<\/span><span class=\"has-inline-color has-vivid-red-color\">), <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"No finalizado\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Finalizado\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this example we&#8217;ve included not nested in an if() function; as we see, this function loses the parentheses and works as a negation operator.<\/p>\n<\/div>\n<\/div>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>This function allows the use of regular expressions; if you want to learn how to use them, <a href=\"https:\/\/lacolmenatecnologica.com\/cursos\/curso-de-notion\/lecciones\/6-tablas-en-notion-ii-formulas-y-funciones\/temas\/expresiones-regulares-en-notion\/\">click here<\/a>.<\/p><\/blockquote>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"13-or-prueba-l%C3%B3gica-prueba-l%C3%B3gica-\"><span class=\"has-inline-color has-vivid-red-color\">or(<\/span>logical test<span class=\"has-inline-color has-vivid-red-color\">,<\/span> logical test<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">If one or both logical tests return <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code>. If both are <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code>, it returns <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code>. Returns a boolean.  <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">or(2==2, 1==3)<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 2:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">or(2==4, 1==3)<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The first comparison expression, must evaluate a logical test resulting in a boolean value.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> The second comparison expression, must evaluate a logical test resulting in a boolean value.<\/p>\n<\/div>\n<\/div>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>This function allows the use of regular expressions; if you want to learn how to use them, <a href=\"https:\/\/lacolmenatecnologica.com\/cursos\/curso-de-notion\/lecciones\/6-tablas-en-notion-ii-formulas-y-funciones\/temas\/expresiones-regulares-en-notion\/\">click here<\/a>.<\/p><\/blockquote>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"14-smaller-valor-valor-\"><span class=\"has-inline-color has-vivid-red-color\">smaller(<\/span>value<span class=\"has-inline-color has-vivid-red-color\">,<\/span> value<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Returns <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> (true) if the first argument is smaller than the second and <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code> (false) otherwise. We can evaluate any type of value: text, numbers, dates, or booleans. If the values are equal it would return <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code>. Both parameters must be of the same type (number, text, &#8230;). Returns a boolean.    <\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"195\" src=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-smaller-1.jpg\" alt=\"Notion smaller() function\" class=\"wp-image-5674\" srcset=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-smaller-1.jpg 555w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-smaller-1-500x176.jpg 500w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><figcaption>The formula is included in the \u01a9 Formula property<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">smaller( \"Ac\",\"Ab\")<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code><br\/><em>Example 2:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">smaller( 2, 3 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code><br\/>Example 3: <code><span class=\"has-inline-color has-vivid-red-color\">smaller(prop(\"Fecha 1\"),prop(\"Fecha 2\"))<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code><br\/><em>Example 4:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">smaller( true, false )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The first expression, which can evaluate any type of value, for example, a number, text, date, or boolean.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> The expression against which to compare the first. Its value type must match the value type of the first expression. <\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"557\" height=\"195\" src=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-smaller-2.jpg\" alt=\"Notion smaller() function\" class=\"wp-image-5675\" srcset=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-smaller-2.jpg 557w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-smaller-2-500x175.jpg 500w\" sizes=\"auto, (max-width: 557px) 100vw, 557px\" \/><figcaption>The formula is included in the \u01a9 Formula property<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>How are texts evaluated with larger()?<\/strong>  first evaluates the leftmost letter of each argument; in example 1, since the first letter is &#8220;A&#8221; in both arguments, it moves on to evaluate the second letter\u2014in this case the &#8220;c&#8221; of the first argument is greater than the &#8220;b&#8221; of the second argument because letters have the value of their order in the alphabet, and in this case &#8220;c&#8221; is in the third position and therefore is greater than the &#8220;b&#8221; of the second argument. Any lowercase letter is greater than any uppercase letter. <br\/><br\/><strong>And dates?<\/strong>  the most recent date is always the largest.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Booleans<\/strong>: if it&#8217;s <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> it has value <code><span class=\"has-inline-color has-vivid-red-color\">1<\/span><\/code>, and if it&#8217;s <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code> it has value <code><span class=\"has-inline-color has-vivid-red-color\">0<\/span><\/code>. Therefore the value <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> is always greater than <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code>. <\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"15-smallereq-valor-valor-\"><span class=\"has-inline-color has-vivid-red-color\">smallerEq(<\/span>value<span class=\"has-inline-color has-vivid-red-color\">,<\/span> value<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Returns <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> (true) if the first argument is smaller than the second and <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code> (false) otherwise. We can evaluate any type of value: text, numbers, dates, or booleans. If the values are equal it would return <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code>. Both parameters must be of the same type (number, text, &#8230;). Returns a boolean.    <\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"557\" height=\"196\" src=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-smallereq-1.jpg\" alt=\"Notion smallerEq() function\" class=\"wp-image-5676\" srcset=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-smallereq-1.jpg 557w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-smallereq-1-500x176.jpg 500w\" sizes=\"auto, (max-width: 557px) 100vw, 557px\" \/><figcaption>The formula is included in the \u01a9 Formula property<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">smallerEq( \"Ac\",\"Ab\")<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code><br\/><em>Example 2:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">smallerEq( 2, 3 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code><br\/>Example 3: <code><span class=\"has-inline-color has-vivid-red-color\">smallerEq(prop(\"Fecha 1\"),prop(\"Fecha 2\"))<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code><br\/><em>Example 4:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">smallerEq( true, false )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The first expression, which can evaluate any type of value, for example, a number, text, date, or boolean.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> The expression against which to compare the first. Its value type must match the value type of the first expression. <\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"557\" height=\"196\" src=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-smallereq-2.jpg\" alt=\"Notion smallerEq() function\" class=\"wp-image-5677\" srcset=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-smallereq-2.jpg 557w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-smallereq-2-500x176.jpg 500w\" sizes=\"auto, (max-width: 557px) 100vw, 557px\" \/><figcaption>The formula is included in the \u01a9 Formula property<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>How are texts evaluated with larger()?<\/strong>  first evaluates the leftmost letter of each argument; in example 1, since the first letter is &#8220;A&#8221; in both arguments, it moves on to evaluate the second letter\u2014in this case the &#8220;c&#8221; of the first argument is greater than the &#8220;b&#8221; of the second argument because letters have the value of their order in the alphabet, and in this case &#8220;c&#8221; is in the third position and therefore is greater than the &#8220;b&#8221; of the second argument. Any lowercase letter is greater than any uppercase letter. <br\/><br\/><strong>And dates?<\/strong>  the most recent date is always the largest.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Booleans<\/strong>: if it&#8217;s <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> it has value <code><span class=\"has-inline-color has-vivid-red-color\">1<\/span><\/code>, and if it&#8217;s <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code> it has value <code><span class=\"has-inline-color has-vivid-red-color\">0<\/span><\/code>. Therefore the value <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> is always greater than <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code>. <\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"16-unequal-valor-valor-\"><span class=\"has-inline-color has-vivid-red-color\">unequal(<\/span>value<span class=\"has-inline-color has-vivid-red-color\">,<\/span> value<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Checks whether the values returned from two expressions are unequal. Returns a boolean. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">unequal( 2, 3 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 2:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">unequal( <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"rojo\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"rojo\"<\/span><span class=\"has-inline-color has-vivid-red-color\"> )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 3:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">unequal(6 <\/span><span style=\"color:#a57e4f\" class=\"has-inline-color\">*<\/span><span class=\"has-inline-color has-vivid-red-color\"> 9, 42 ) <\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 4:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">unequal( true, <\/span><span style=\"color:#a57e4f\" class=\"has-inline-color\">not<\/span><span class=\"has-inline-color has-vivid-red-color\"> false ) <\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Equivalent operator:<\/strong> <code><span class=\"has-inline-color has-vivid-red-color\">[expresi\u00f3n] != [expresi\u00f3n]<\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"194\" src=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-unequal.jpg\" alt=\"Notion unequal() function\" class=\"wp-image-5678\" srcset=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-unequal.jpg 555w, https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/03\/notion-funcion-unequal-500x175.jpg 500w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><figcaption>The formula is included in the \u01a9 Formula property<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The expression to check, which can evaluate any type of value, for example, a number, text string, date, or boolean.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> The expression to check, which can evaluate any type of value, for example, a number, text string, date, or boolean.<\/p>\n<\/div>\n<\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n<h2 class=\"wp-block-heading\" id=\"17-funciones-num%C3%A9ricas-de-notion\">Notion Numeric Functions<\/h2>\n\n<p class=\"wp-block-paragraph\">Numeric functions perform mathematical operations with numbers and <strong>always return a number<\/strong>. Below you can see a table with the mathematical operators we can use to perform these operations. <\/p>\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Operator<\/th><th>Description<\/th><th>Examples<\/th><\/tr><\/thead><tbody><tr><td><code><span class=\"has-inline-color has-vivid-red-color\">-<\/span><\/code><\/td><td>Subtracts the right operand from the left operand to return their difference.<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">4 - 2<\/span><\/code>  \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">2<\/span><\/code><\/td><\/tr><tr><td><code><span class=\"has-inline-color has-vivid-red-color\">+<\/span><\/code><\/td><td>Adds numeric operands to return their sum, or concatenates (combines) text operands (text strings).<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">2 + 2<\/span><\/code>  \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">4<\/span><\/code><\/td><\/tr><tr><td><code><span class=\"has-inline-color has-vivid-red-color\">*<\/span><\/code><\/td><td>Multiplies its operands to return their product.<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">3 * 6<\/span><\/code>  \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">18<\/span><\/code><\/td><\/tr><tr><td><code><span class=\"has-inline-color has-vivid-red-color\">\/<\/span><\/code><\/td><td>Divides the left operand by the right operand to return their quotient.<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">21 \/ 7<\/span><\/code>  \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">3<\/span><\/code><\/td><\/tr><tr><td><code><span class=\"has-inline-color has-vivid-red-color\">%<\/span><\/code><\/td><td>The modulo operator returns the remainder after dividing the left operand by the right operand.<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">23 % 7<\/span><\/code>  \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">2<\/span><\/code><\/td><\/tr><tr><td><code><span class=\"has-inline-color has-vivid-red-color\">^<\/span><\/code><\/td><td>Returns the base value raised to the power.<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">2 ^ 4<\/span><\/code>  \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">16<\/span><\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"18-abs-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">abs(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the absolute value of a number. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">abs( -3 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">3<\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The number from which we want to obtain the absolute value.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"19-add-valor-valor-\"><span class=\"has-inline-color has-vivid-red-color\">add(<\/span>value<span class=\"has-inline-color has-vivid-red-color\">,<\/span> value<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Adds two numbers and returns their sum. Also concatenates two character strings and returns the sum of both. Returns a number or text depending on the type of its arguments.  <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">add( 3 , 4 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">7<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 2:<\/em> <code><code><span class=\"has-inline-color has-vivid-red-color\">add( <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Hola \"<\/span><span class=\"has-inline-color has-vivid-red-color\"> , <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"mundo\"<\/span><span class=\"has-inline-color has-vivid-red-color\"> )<\/span><\/code><\/code>\u2192  <code><span class=\"has-inline-color has-vivid-red-color\">Hola mundo<\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> First number or text of the sum or concatenation.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> Second number or text of the sum or concatenation.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"20-cbrt-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">cbrt(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the cube root of a number. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">cbrt( 8 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">2<\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The number from which we want to obtain the cube root.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"21-ceil-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">ceil(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the smallest integer greater than or equal to a number. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">ceil( 4.2 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">5<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The number from which we want to obtain the nearest greater or equal integer.<\/p>\n<\/div>\n<\/div>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Notion uses a period as the decimal separator.<\/p><\/blockquote>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"22-divide-n%C3%BAmero-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">divide(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">,<\/span> number<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Divides two numbers and returns their quotient. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">divide( 21, 7 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">3<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> Dividend.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> Divisor.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"23-exp-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">exp(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns E ^ x, where x is the argument and E is Euler&#8217;s constant (2.718&#8230;), the base of the natural logarithm. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">exp( 2 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">7.389056098931<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The number that will serve as the exponent of E.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"24-floor-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">floor(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the largest integer less than or equal to a number. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">floor( 4.2 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">4<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The number from which we want to obtain the nearest smaller or equal integer.<\/p>\n<\/div>\n<\/div>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Notion uses a period as the decimal separator.<\/p><\/blockquote>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"25-ln-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">ln(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the natural logarithm, also known as the Napierian logarithm, of a number. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">ln( 3 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">1.098612288668<\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The number from which we want to obtain the Napierian logarithm.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"26-log10-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">log10(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the base-10 logarithm of a number. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">log10( 100 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">2<\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The number from which we want to obtain the base-10 logarithm.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"27-log2-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">log2(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the base-2 logarithm of a number. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">log2( 8 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">3<\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The number from which we want to obtain the base-2 logarithm.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"28-max-n%C3%BAmero-n%C3%BAmero-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">max(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">,<\/span> number<span class=\"has-inline-color has-vivid-red-color\">,<\/span> number<span class=\"has-inline-color has-vivid-red-color\">,<\/span> &#8230;<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the largest number from a list; we can add as many numbers as we want, separated by commas. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">max( 2, 5, 7, 21, 3 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">21<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Arguments 1, 2, 3, &#8230;:<\/strong> List of numbers separated by commas.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"29-min-n%C3%BAmero-n%C3%BAmero-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">min(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">,<\/span> number<span class=\"has-inline-color has-vivid-red-color\">,<\/span> number<span class=\"has-inline-color has-vivid-red-color\">,<\/span> &#8230;<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the smallest number from a list; we can add as many numbers as we want, separated by commas. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">min( 2, 5, 7, 21, 3 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">2<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Arguments 1, 2, 3, &#8230;:<\/strong> List of numbers separated by commas.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"30-mod-n%C3%BAmero-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">mod(<\/span>number, number<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Divides two numbers and returns the remainder. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">mod( 7, 3 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">1<\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> Dividend.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> Divisor.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"31-multiply-n%C3%BAmero-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">multiply(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">,<\/span> number<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Multiplies two numbers and returns their product. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">multiply( 2 , 3 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">6<\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> First number or factor of the multiplication.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> Second number or factor of the multiplication.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"32-pow-n%C3%BAmero-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">pow(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">,<\/span> number<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the base raised to the power of the exponent. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">pow( 2 , 5 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">32<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> Base.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> Exponent.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"33-round-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">round(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the value of a number rounded to the nearest integer. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">round( 4.4 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">4<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">round( 4.5 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">5<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> Number to round.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"34-sign-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">sign(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the sign of a number: if it&#8217;s positive it returns <code><span class=\"has-inline-color has-vivid-red-color\">1<\/span><\/code>, if it&#8217;s negative it returns <code><span class=\"has-inline-color has-vivid-red-color\">-1<\/span><\/code>, and if it&#8217;s zero it returns <code><span class=\"has-inline-color has-vivid-red-color\">0<\/span><\/code>. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">sign( -9 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">-1<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">sign( 5 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">1<\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">sign( 0 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">0<\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> Number from which we want to return the sign.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"35-sqrt-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">sqrt(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the square root of a number. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">sqrt( 16 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">4<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> Number from which we want to return the square root.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"36-subtract-n%C3%BAmero-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">subtract(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">,<\/span> number<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Subtracts two numbers and returns their difference. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">subtract( 4 , 3 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">1<\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> First number or minuend of the subtraction.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> Second number or subtrahend of the subtraction.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"37-tonumber-texto-\"><span class=\"has-inline-color has-vivid-red-color\">toNumber(<\/span>text<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Converts text to a number. If the text string begins with a number followed by text, it takes that number and returns it as a result. Returns a number.  <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">toNumber( <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"7\"<\/span><span class=\"has-inline-color has-vivid-red-color\"> )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">7<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">toNumber( <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"51 productos\"<\/span><span class=\"has-inline-color has-vivid-red-color\"> )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">51<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The number to convert.<\/p>\n<\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"38-unaryminus-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">unaryMinus(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Converts a negative number to positive or a positive number to negative. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">unaryMinus( -2 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">2<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 2:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">unaryMinus( 3 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">-3<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The number to convert.<\/p>\n<\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Equivalent operator:<\/strong> <code><span class=\"has-inline-color has-vivid-red-color\">[n\u00famero] * -1<\/span><\/code><\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"39-unaryplus-texto-\"><span class=\"has-inline-color has-vivid-red-color\">unaryPlus(<\/span>text<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Converts text to a number. If the text string begins with a number followed by text, unlike <code><span class=\"has-inline-color has-vivid-red-color\">toNumber()<\/span><\/code>, it does not take that number and returns an empty field. Returns a number.  <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">unaryPlus( <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"7\"<\/span><span class=\"has-inline-color has-vivid-red-color\"> )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">7<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">unaryPlus( <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"51 productos\"<\/span><span class=\"has-inline-color has-vivid-red-color\"> )<\/span><\/code> \u2192  <\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The text to convert.<\/p>\n<\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n<h2 class=\"wp-block-heading\" id=\"40-funciones-de-textos-de-notion\">Notion Text Functions<\/h2>\n\n<p class=\"wp-block-paragraph\">Functions with which you can make changes and perform processes related to text or properties that contain text.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"41-concat-texto-texto-\"><span class=\"has-inline-color has-vivid-red-color\">concat(<\/span>text, text, &#8230;<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Concatenates or combines text; there&#8217;s no limit to the number of arguments\u2014you can include as many as you want. Returns text. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">concat( <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"La \"<\/span><span class=\"has-inline-color has-vivid-red-color\">,<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Colmena \"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Tecnol\u00f3gica\"<\/span><span class=\"has-inline-color has-vivid-red-color\"> )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">\"La Colmena Tecnol\u00f3gica\"<\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Arguments:<\/strong> The texts to concatenate.<\/p>\n<\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"42-contains-texto-texto-\"><span class=\"has-inline-color has-vivid-red-color\">contains(<\/span>text<span class=\"has-inline-color has-vivid-red-color\">,<\/span> text<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code> (true) if the second argument is found within the first. Returns a boolean. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">contains( <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"notion\"<\/span><span class=\"has-inline-color has-vivid-red-color\">,<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"ion\"<\/span><span class=\"has-inline-color has-vivid-red-color\"> )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">contains( <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"La Colmena\"<\/span><span class=\"has-inline-color has-vivid-red-color\">,<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Tec\"<\/span><span class=\"has-inline-color has-vivid-red-color\"> )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The text where we want to search.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The text to search for.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"43-format-valor-\"><span class=\"has-inline-color has-vivid-red-color\">format(<\/span>value<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Converts a number, date, or boolean into text. Returns a string. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">format( 3 )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">\"3\"<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The number, date, or boolean to convert.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"44-join-texto-texto-\"><span class=\"has-inline-color has-vivid-red-color\">join(<\/span>text, text, &#8230;<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Concatenates or combines text strings with a specified delimiter. Returns a string. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">join( <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\", \"<\/span><span class=\"has-inline-color has-vivid-red-color\">,<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Olga\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Mar\u00eda\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Fernando\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Luisa\"<\/span><span class=\"has-inline-color has-vivid-red-color\"> )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">\"Olga, Mar\u00eda, Fernando, Luisa\"<\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Arguments:<\/strong> The first argument is the delimiter, a text string. The remaining arguments are the texts to be combined, separated by the delimiter. You can include as many arguments as you like.  <\/p>\n<\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"45-length-texto-expresi%C3%B3n-texto-\"><span class=\"has-inline-color has-vivid-red-color\">length(<\/span>text, expression, text<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the number of characters in a text string. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">length( <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"La Colmena Tecnol\u00f3gica\"<\/span><span class=\"has-inline-color has-vivid-red-color\"> )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">22<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The text for which to return the length.<\/p>\n<\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"46-replace-texto-expresi%C3%B3n-texto-\"><span class=\"has-inline-color has-vivid-red-color\">replace(<\/span>text<span class=\"has-inline-color has-vivid-red-color\">,<\/span> expression<span class=\"has-inline-color has-vivid-red-color\">,<\/span> text<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Replaces the first match of a regular expression within a text string with a specified new text. Returns a text string. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">replace( <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"La verdad\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"La\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Es\"<\/span><span class=\"has-inline-color has-vivid-red-color\"> )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">\"Es verdad\"<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 2:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">replace(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"1-2-3\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"-\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"!\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">\"1!2-3\"<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 3:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">replace(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Mi nombre es Isabel\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"(?&lt;=es ).+(?=.)\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Mar\u00eda\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">\"Mi nombre es Mar\u00eda\"<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The original text.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> Text or Regular Expression (in quotes).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 3:<\/strong> The replacement text.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Example 3 uses regular expressions; if you want to learn how to use them, <a href=\"https:\/\/lacolmenatecnologica.com\/cursos\/curso-de-notion\/lecciones\/6-tablas-en-notion-ii-formulas-y-funciones\/temas\/expresiones-regulares-en-notion\/\">click here<\/a><\/p><\/blockquote>\n<\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"47-replaceall-texto-expresi%C3%B3n-texto-\"><span class=\"has-inline-color has-vivid-red-color\">replaceAll(<\/span>text<span class=\"has-inline-color has-vivid-red-color\">,<\/span> expression<span class=\"has-inline-color has-vivid-red-color\">,<\/span> text<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Replaces the first match of a regular expression within a text string with a specified new text. Returns a text string. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">replaceAll( <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Me gusta el verano. Me gusta nadar\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Me gusta\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Me encanta\"<\/span><span class=\"has-inline-color has-vivid-red-color\"> )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">\"Me encanta el verano. Me encanta nadar.\"<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 2:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">replaceAll(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">prop(\"Nombre\")<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Dra?.  \"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">Sustituye \"Dr. \" o \"Dra. \" que hubiera cualquier registro de la tabla por nada \"\", es decir los elimina. <\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The original text.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> Text or Regular Expression (in quotes).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 3:<\/strong> The replacement text.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Example 3 uses regular expressions; if you want to learn how to use them, <a href=\"https:\/\/lacolmenatecnologica.com\/cursos\/curso-de-notion\/lecciones\/6-tablas-en-notion-ii-formulas-y-funciones\/temas\/expresiones-regulares-en-notion\/\">click here<\/a><\/p><\/blockquote>\n<\/div>\n<\/div>\n\n\n\n\n\n<h3 class=\"wp-block-heading\" id=\"48-slice-texto-n%C3%BAmero-n%C3%BAmero-\">slice(<em><span class=\"has-inline-color has-vivid-red-color\">text<\/span><\/em>, <em><span class=\"has-inline-color has-vivid-red-color\">number<\/span><\/em>, <em><span class=\"has-inline-color has-vivid-red-color\">number<\/span><\/em>)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The <em><span class=\"has-inline-color has-vivid-red-color\">slice()<\/span><\/em> function returns a segment or part of the text provided. This function requires at least two parameters, although you can optionally use three: <\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Original text from which we will obtain a part.<\/li><li>Start point, where the first character is <code><span class=\"has-inline-color has-vivid-red-color\">0<\/span><\/code>.<\/li><li>End point (optional)<\/li><\/ol>\n\n\n\n<p class=\"has-very-light-gray-background-color has-background wp-block-paragraph\"><em>Example 1:<\/em> <strong><code><span class=\"has-inline-color has-vivid-red-color\">slice(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"La Colmena Tecnol\u00f3gica.\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, 3, 10)<\/span><\/code><\/strong> \u2192 &#8220;Colmena&#8221;<\/p>\n\n\n\n<p class=\"has-very-light-gray-background-color has-background wp-block-paragraph\"><em>Example 2:<\/em> <strong><code><span class=\"has-inline-color has-vivid-red-color\">slice(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"La Colmena Tecnol\u00f3gica.\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, 11, 22)<\/span><\/code><\/strong> \u2192 &#8220;Tecnol\u00f3gica&#8221;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img alt=\"\" decoding=\"async\" src=\"https:\/\/lacolmenatecnologica.com\/wp-content\/uploads\/2020\/07\/notion-slice.png\" alt=\"\" class=\"wp-image-9715\"\/><\/figure><\/div>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Blank spaces also count as a character. <strong>Unlike the start point, the end point parameter does not include the character at that position<\/strong>; therefore, to include the final character, you must set the position immediately after it.<\/p><\/blockquote>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"49-test-prueba-\"><span class=\"has-inline-color has-vivid-red-color\">test(<\/span>test<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Checks if a text string matches a regular expression. Returns a boolean. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">test( <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Rojo<\/span><span style=\"color:#669900\" class=\"has-inline-color\"><\/span><span style=\"color:#669900\" class=\"has-inline-color\">, Verde, Azul\"<\/span><span class=\"has-inline-color has-vivid-red-color\">, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Verde\"<\/span><span class=\"has-inline-color has-vivid-red-color\"> )<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 2:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">test(prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Nombre\"<\/span><span class=\"has-inline-color has-vivid-red-color\">), <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"^A|^C\"<\/span><span style=\"color:#669900\" class=\"has-inline-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">Devuelve true para cualquier nombre que empiece por A o por C.<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The original text.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> Text or Regular Expression (in quotes).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 3:<\/strong> The replacement text.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Example 3 uses regular expressions; if you want to learn how to use them, <a href=\"https:\/\/lacolmenatecnologica.com\/cursos\/curso-de-notion\/lecciones\/6-tablas-en-notion-ii-formulas-y-funciones\/temas\/expresiones-regulares-en-notion\/\">click here<\/a><\/p><\/blockquote>\n<\/div>\n<\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n<h2 class=\"wp-block-heading\" id=\"50-funciones-fecha-y-hora-de-notion\">Notion Date and Time Functions<\/h2>\n\n<p class=\"wp-block-paragraph\">These functions help perform operations with date and time properties. For example, to calculate how many days have passed between two dates, extract a single piece of data from a date (day, month, year), and much more. Let&#8217;s explore each of these functions.   <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"51-date-fecha-\"><span class=\"has-inline-color has-vivid-red-color\">date(<\/span>date<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the day of the month, an integer between 1 and 31, for a given date. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">date(now())<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">[current_date format=\"d\"]<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 2:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">date(prop(<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"Fecha\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><span style=\"color:#669900\" class=\"has-inline-color\"><\/span><span style=\"color:#669900\" class=\"has-inline-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">Devuelve d\u00eda que tenga la fecha de la propiedad Fecha.<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The date from which to identify the day of the month.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Notion only allows you to get a date through a <span class=\"has-inline-color has-vivid-red-color\">Date<\/span> property or through the <span class=\"has-inline-color has-vivid-red-color\">now()<\/span> function, which returns the current date and time.<\/p><\/blockquote>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"52-dateadd-fecha-n%C3%BAmero-texto-\"><span class=\"has-inline-color has-vivid-red-color\">dateAdd(<\/span>date, number, text<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Add time to a date. The last argument can be one of the following:  <code><span style=\"color:#669900\" class=\"has-inline-color\">\"years\"<\/span><\/code>  (years), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"quarters\"<\/span><\/code>  (quarters), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"months\"<\/span><\/code>  (months), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"weeks\"<\/span><\/code>  (weeks), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"days\"<\/span><\/code>  (days), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"hours\"<\/span><\/code>  (hours), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"minutes\"<\/span><\/code>  (minutes), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"seconds\"<\/span><\/code>  (seconds), or <code><span style=\"color:#669900\" class=\"has-inline-color\">\"miliseconds\"<\/span><\/code>  (milliseconds). Returns a date. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">dateAdd(now(), 1, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"months\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192 Assuming today is 08\/15\/2021, the result is <code><span class=\"has-inline-color has-vivid-red-color\"> Sep 15, 2020 10:46 AM<\/span><\/code><span class=\"has-inline-color has-vivid-red-color\"> <\/span>(this result can be formatted with the <code><span class=\"has-inline-color has-vivid-red-color\">formatDate()<\/span><\/code> function). <\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The initial date.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> The amount to add.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 3:<\/strong> The time unit, which can be years, quarters, months, weeks, days, hours, minutes, seconds, milliseconds, in quotes.<\/p>\n<\/div>\n<\/div>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Notion only allows you to get a date through a <span class=\"has-inline-color has-vivid-red-color\">Date<\/span> property or through the <span class=\"has-inline-color has-vivid-red-color\">now()<\/span> function, which returns the current date and time.<\/p><\/blockquote>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"53-datebetween-fecha-fecha-texto-\"><span class=\"has-inline-color has-vivid-red-color\">dateBetween(<\/span>date, date, text<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the amount of time between two dates. The last argument can be one of the following:  <span style=\"color:#669900\" class=\"has-inline-color\"><code>\"years\"<\/code> <\/span>(years), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"quarters\"<\/span><\/code>  (quarters), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"months\"<\/span><\/code>  (months), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"weeks\"<\/span><\/code>  (weeks), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"days\"<\/span><\/code>  (days), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"hours\"<\/span><\/code>  (hours), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"minutes\"<\/span><\/code>  (minutes), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"seconds\"<\/span><\/code>  (seconds), or <code><span style=\"color:#669900\" class=\"has-inline-color\">\"miliseconds\"<\/span><\/code>  (milliseconds). Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">dateBetween(now(), prop(\"Created time\"), <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"minutes\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192  <code><span class=\"has-inline-color has-vivid-red-color\">43<\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The later date.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> The earlier date.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 3:<\/strong> The time unit, which can be years, quarters, months, weeks, days, hours, minutes, seconds, milliseconds, in quotes.<\/p>\n<\/div>\n<\/div>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Notion only allows you to get a date through a <span class=\"has-inline-color has-vivid-red-color\">Date<\/span> property or through the <span class=\"has-inline-color has-vivid-red-color\">now()<\/span> function, which returns the current date and time.<\/p><\/blockquote>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"54-datesubtract-fecha-n%C3%BAmero-texto-\"><span class=\"has-inline-color has-vivid-red-color\">dateSubtract(<\/span>date, number, text<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Subtract time from a date. The last argument can be one of these:  <code><span style=\"color:#669900\" class=\"has-inline-color\">\"years\"<\/span><\/code>  (years), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"quarters\"<\/span><\/code>  (quarters), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"months\"<\/span><\/code>  (months), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"weeks\"<\/span><\/code>  (weeks), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"days\"<\/span><\/code>  (days), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"hours\"<\/span><\/code>  (hours), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"minutes\"<\/span><\/code>  (minutes), <code><span style=\"color:#669900\" class=\"has-inline-color\">\"seconds\"<\/span><\/code>  (seconds), or <code><span style=\"color:#669900\" class=\"has-inline-color\">\"miliseconds\"<\/span><\/code>  (milliseconds). Returns a date. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">dateSubtract(now(), 1, <\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"years\"<\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192 Assuming today is 08\/15\/2021, the result is <code><span class=\"has-inline-color has-vivid-red-color\">Aug 15, 2020 11:45 AM<\/span><\/code> (this result can be formatted with the <code><span class=\"has-inline-color has-vivid-red-color\">formatDate()<\/span><\/code> function).<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The initial date.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> The amount to subtract.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 3:<\/strong> The time unit, which can be years, quarters, months, weeks, days, hours, minutes, seconds, milliseconds, in quotes.<\/p>\n<\/div>\n<\/div>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Notion only allows you to get a date through a <span class=\"has-inline-color has-vivid-red-color\">Date<\/span> property or through the <span class=\"has-inline-color has-vivid-red-color\">now()<\/span> function, which returns the current date and time.<\/p><\/blockquote>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"55-day-fecha-\"><span class=\"has-inline-color has-vivid-red-color\">day(<\/span>date<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the index (number) of the day of the week for a date, where Sunday is 0, Monday is 1, and so on. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">day(now()<\/span><span style=\"color:#669900\" class=\"has-inline-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192 <code><span class=\"has-inline-color has-vivid-red-color\">[current_date format=\"w\"]<\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The date for which to identify the day of the week.<\/p>\n<\/div>\n<\/div>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Notion only allows you to get a date through a <span class=\"has-inline-color has-vivid-red-color\">Date<\/span> property or through the <span class=\"has-inline-color has-vivid-red-color\">now()<\/span> function, which returns the current date and time.<\/p><\/blockquote>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"56-end-fecha-\"><span class=\"has-inline-color has-vivid-red-color\">end(<\/span>date<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the end date of a date property that contains a date range. Returns a date. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">end(prop(\"Duraci\u00f3n\")<\/span><span style=\"color:#669900\" class=\"has-inline-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192 <code><span class=\"has-inline-color has-vivid-red-color\"><code>Jun 27, 2020 21:15 AM<\/code><\/span><\/code> (this result can be formatted with the <code><span class=\"has-inline-color has-vivid-red-color\">formatDate()<\/span><\/code> function).<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> A reference to a Date property that contains an end date.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"57-formatdate-fecha-text-\"><span class=\"has-inline-color has-vivid-red-color\">formatDate(<\/span>date, text<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Formats a date with the standard Moment time format string.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">formatDate(now(),<\/span><span style=\"color:#669900\" class=\"has-inline-color\">\"DD\/MM\/YYYY\"<\/span><span style=\"color:#669900\" class=\"has-inline-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192 <code><span class=\"has-inline-color has-vivid-red-color\"><code>[current_date format=\"d\/m\/Y\"]<\/code><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The date property or now() that we want to format.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Argument 2:<\/strong> Standard Moment time format in quotes.<\/p>\n<\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"58-formatos-de-fecha\">Date Formats<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Combine these patterns to build the second argument of the function.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Category<\/th><th>Pattern<\/th><th>Representation<\/th><\/tr><\/thead><tbody><tr><td>Year<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">YY<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">YYYY<\/span><\/code><\/td><td>[current_date format=&#8221;y&#8221;]<br\/>[current_date format=&#8221;Y&#8221;]<\/td><\/tr><tr><td>Quarter<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">Q<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">Qo<\/span><\/code><\/td><td>1 &#8230; 4<br\/>1st &#8230; 4th<\/td><\/tr><tr><td>Month<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">M<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">Mo<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">MM<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">MMM<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">MMMM<\/span><\/code><\/td><td>1 &#8230; 12<br\/>1st &#8230; 12th<br\/>01 &#8230; 12<br\/>Jun<br\/>January<\/td><\/tr><tr><td>Week of year<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">w<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">wo<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">ww<\/span><\/code><\/td><td>1 &#8230; 53<br\/>1st &#8230; 53rd<br\/>01 &#8230; 53<\/td><\/tr><tr><td>Day of year<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">DDD<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">DDDo<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">DDDD<\/span><\/code><\/td><td>1 &#8230; 365<br\/>1st &#8230; 365th<br\/>001 &#8230; 365<\/td><\/tr><tr><td>Day<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">D<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">Do<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">DD<\/span><\/code><\/td><td>1 &#8230; 31<br\/>1st &#8230; 31st<br\/>01 &#8230; 31<\/td><\/tr><tr><td>Day of week<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">d<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">dd<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">ddd<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">dddd<\/span><\/code><\/td><td>0 \u2026 6<br\/>Su<br\/>Sun<br\/>Sunday<\/td><\/tr><tr><td>24 hours<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">H<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">HH<\/span><\/code><\/td><td>0 &#8230; 23<br\/>00 &#8230; 23<\/td><\/tr><tr><td>12 hours<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">h<\/span><\/code><br\/><span class=\"has-inline-color has-vivid-red-color\"><code>hh<\/code><\/span><\/td><td>1 &#8230; 12<br\/>01 &#8230; 12<\/td><\/tr><tr><td>Minutes<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">m<br\/>mm<\/span><\/code><\/td><td>0 &#8230; 59<br\/>00 &#8230; 59<\/td><\/tr><tr><td>Seconds<\/td><td><span class=\"has-inline-color has-vivid-red-color\"><code>s<\/code><\/span><br\/><code><span class=\"has-inline-color has-vivid-red-color\">ss<\/span><\/code><\/td><td>0 &#8230; 59<br\/>00 &#8230; 59<\/td><\/tr><tr><td>AM \/ PM<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">a<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">A<\/span><\/code><\/td><td>a.m.<br\/>A.M.<\/td><\/tr><tr><td>Time zone offset<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">Z<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">ZZ<\/span><\/code><\/td><td>+02:00<br\/>+0200<\/td><\/tr><tr><td>Fractional seconds<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">S<\/span><\/code><br\/><code><span class=\"has-inline-color has-vivid-red-color\">SS<\/span><\/code><\/td><td>0 &#8230; 9<br\/>00 &#8230; 99<\/td><\/tr><tr><td>Milliseconds<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">SSS<\/span><\/code><\/td><td>000 \u2026 999<\/td><\/tr><tr><td>Unix timestamp<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">X<\/span><\/code><\/td><td>1597491300<\/td><\/tr><tr><td>Unix millisecond timestamp<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">x<\/span><\/code><\/td><td>1597491300000<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"59-fromtimestamp-n%C3%BAmero-\"><span class=\"has-inline-color has-vivid-red-color\">fromTimestamp(<\/span>number<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns a date value from a Unix millisecond timestamp, or number of milliseconds since January 1, 1970. Returns a date. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">fromTimestamp(159749388000)<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192 <code><span class=\"has-inline-color has-vivid-red-color\"><code>Aug 15, 2020 14:19 AM<\/code><\/span><\/code> (this result can be formatted with the <code><span class=\"has-inline-color has-vivid-red-color\">formatDate()<\/span><\/code> function).<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> Number of a Unix millisecond timestamp, or number of milliseconds that have passed since January 1, 1970.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"60-hour-fecha-\"><span class=\"has-inline-color has-vivid-red-color\">hour(<\/span>date<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the hour of the day, an integer between 0 and 23 from a date. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">hour(now())<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192 <code><span class=\"has-inline-color has-vivid-red-color\"><code><code>[current_date format=\"G\"]<\/code><\/code><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The date\/time value from which we want to get the hour of the day.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"61-minute-fecha-\"><span class=\"has-inline-color has-vivid-red-color\">minute(<\/span>date<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the minute of the hour, an integer between 0 and 59 from a date. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">minute(now())<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192 <code><span class=\"has-inline-color has-vivid-red-color\"><code><code>[current_date format=\"i\"]<\/code><\/code><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The date\/time value from which we want to get the minute.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"62-month-fecha-\"><span class=\"has-inline-color has-vivid-red-color\">month(<\/span>date<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the numeric index of the month of the year, an integer between 0 and 11 from a date, where January is 0, February is 1, &#8230; Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">month(now())<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192 <code><span class=\"has-inline-color has-vivid-red-color\"><code><code>7<\/code><\/code><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The date from which we want to get the numeric index of the month of the year.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"63-now-\"><span class=\"has-inline-color has-vivid-red-color\">now()<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the current date. Returns a date. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">now()<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192 <code><span class=\"has-inline-color has-vivid-red-color\"><code><code>Aug 15, 2021 14:34 PM<\/code><\/code><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Arguments:<\/strong> This function takes no arguments.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"64-start-fecha-\"><span class=\"has-inline-color has-vivid-red-color\">start(<\/span>date<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the start date of a date property that contains a date range. Returns a date. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">start(prop(\"Duraci\u00f3n\")<\/span><span style=\"color:#669900\" class=\"has-inline-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\">)<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192 <code><span class=\"has-inline-color has-vivid-red-color\"><code>Jun 01, 2020 21:15 AM<\/code><\/span><\/code> (this result can be formatted with the <code><span class=\"has-inline-color has-vivid-red-color\">formatDate()<\/span><\/code> function).<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> A reference to a Date property that contains a start date.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"65-timestamp-fecha-\"><span class=\"has-inline-color has-vivid-red-color\">timestamp(<\/span>date<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the Unix millisecond timestamp, or number of milliseconds since January 1, 1970 from the given date. Returns a date. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">timestamp(now())<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192 <code><span class=\"has-inline-color has-vivid-red-color\"><code><code>159749388000<\/code><\/code><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The date from which we want to get the timestamp.<\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"66-year-fecha-\"><span class=\"has-inline-color has-vivid-red-color\">year(<\/span>date<span class=\"has-inline-color has-vivid-red-color\">)<\/span><\/h2>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\">Returns the year of a date. Returns a number. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Example 1:<\/em> <code><span class=\"has-inline-color has-vivid-red-color\">year(now())<\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><span class=\"has-inline-color has-vivid-red-color\"><\/span><\/code> \u2192 <code><span class=\"has-inline-color has-vivid-red-color\"><code><code><code><code>[current_date format=\"Y\"]<\/code><\/code><\/code><\/code><\/span><\/code><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Argument 1:<\/strong> The date from which we want to get the year.<\/p>\n<\/div>\n<\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n<h2 class=\"wp-block-heading\" id=\"67-constantes\">Constants<\/h2>\n\n<p class=\"wp-block-paragraph\">These are fixed values that cannot be altered or modified, only read. We can use them in formulas: <\/p>\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Constant<\/th><th>Description<\/th><th>Value<\/th><\/tr><\/thead><tbody><tr><td><code><span class=\"has-inline-color has-vivid-red-color\">e<\/span><\/code><\/td><td>The base of the natural or Napierian logarithm.<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">2.718281828459<\/span><\/code><\/td><\/tr><tr><td><code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code><\/td><td>False or <code>0<\/code><\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">false<\/span><\/code><\/td><\/tr><tr><td><code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code><\/td><td>True or <code>1<\/code><\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">true<\/span><\/code><\/td><\/tr><tr><td><code><span class=\"has-inline-color has-vivid-red-color\">pi<\/span><\/code><\/td><td>The ratio between the circumference of a circle and its diameter<\/td><td><code><span class=\"has-inline-color has-vivid-red-color\">3.14159265359<\/span><\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Formulas and Functions in Notion Below we will break down technical details and examples for each Notion function, operator, and constant, as well as the patterns used to format dates using the formatDate() function. Formulas Formulas are calculation expressions that we can use in Formula type properties, which can be composed of operators, functions, numeric [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":6493,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_titles_title":"Formulas and Functions in Notion: Step-by-Step Practical Guide","_seopress_titles_desc":"Learn to use formulas and functions in Notion to automate calculations, dates, and properties in your databases. See examples.","_seopress_robots_index":"","_seopress_robots_follow":"","_seopress_robots_imageindex":"","_seopress_robots_snippet":"","_seopress_robots_primary_cat":"","_seopress_robots_breadcrumbs":"","_seopress_robots_freeze_modified_date":"","_seopress_robots_custom_modified_date":"","_seopress_robots_canonical":"","_seopress_social_fb_title":"","_seopress_social_fb_desc":"","_seopress_social_fb_img":"","_seopress_social_fb_img_attachment_id":0,"_seopress_social_fb_img_width":0,"_seopress_social_fb_img_height":0,"_seopress_social_twitter_title":"","_seopress_social_twitter_desc":"","_seopress_social_twitter_img":"","_seopress_social_twitter_img_attachment_id":0,"_seopress_social_twitter_img_width":0,"_seopress_social_twitter_img_height":0,"_seopress_redirections_value":"","_seopress_redirections_enabled":"","_seopress_redirections_enabled_regex":"","_seopress_redirections_logged_status":"","_seopress_redirections_param":"","_seopress_redirections_type":0,"_seopress_analysis_target_kw":"","_seopress_news_disabled":"","_seopress_video_disabled":"","_seopress_video":[],"_seopress_pro_schemas_manual":[],"_seopress_pro_rich_snippets_disable_all":"","_seopress_pro_rich_snippets_disable":[],"_seopress_pro_schemas":[],"footnotes":"","_bricks_page_content_2":[],"_bricks_page_header_2":[],"_bricks_page_footer_2":[]},"categories":[381],"tags":[382,383],"class_list":["post-6492","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-notion","tag-databases-in-notion","tag-productivity"],"_links":{"self":[{"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/posts\/6492","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/comments?post=6492"}],"version-history":[{"count":1,"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/posts\/6492\/revisions"}],"predecessor-version":[{"id":6494,"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/posts\/6492\/revisions\/6494"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/media\/6493"}],"wp:attachment":[{"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/media?parent=6492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/categories?post=6492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lacolmenatecnologica.com\/en\/wp-json\/wp\/v2\/tags?post=6492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}