“IF function” will return something if the first value is “true” and something else if the second is false. The "If function" is the most…

The filter function searches in a collection for one or more conditions and removes all items that don’t fit that condition. Usage It follows a…

The split Function breaks down your string into an array of strings using the delimiter that you defined. Think of the delimiter as a border.…

The toLower Function sets all items in a string to lowercase. There is the toUpper function also, and these functions are super useful, mainly if…

Showing errors to the end-user is quite ugly, so we should be careful in protecting our formulas so that you don't display to the user…

The toUpper Function sets all items in a string to uppercase. There is the toLower function also, and these functions are super useful, mainly if…