-
What are functions, conditions, and operators?
-
How to provide an output based on a condition using IfElse()?
-
How to get the value from a specific column and row within a data source using DataSources[]?
-
How to get the value from a specific column and row within an external data source using ExternalDataSources[]?
-
How to compare one value to multiple values and return results accordingly using Switch()?
-
How to translate terms or sentences using Translate()?
-
How to format date and time using FormatDateTime()?
-
How to display the current date using Now()?
-
How to add days, weeks, months, quarters, or years to a selected date using DateAdd()?
-
How to subtract days, weeks, months, quarters, or years from a selected date using DateSubtract()?
-
How to transform a date and time in text format into a date object using DateValue()?
-
How join multiple pieces of text with a separator using StringJoin()?
-
How to join two pieces of text together using Concat()?
-
How to convert text to upper case using Upper()?
-
How to convert text to lower case using Lower ()?
-
How to convert text to proper case using Proper()?
-
How to convert text to sentence case using SentenceCase()?
-
How to generate a unique number using Ticks()?
-
How to use functions GreaterThan(), LessThan() and Equals() with number values
-
How to format a number input using FormatNumber()?
-
How to reverse the value of a True/False using Not()?
-
How to use functions And() and Or() with multiple True/False arguments?
-
How to determine if two values are equal using Equals()?
-
How to determine if the source text contains a specific search value using Contains()?