- How to use functions Add(), Subtract(), Multiply() and Divide() to calculate with numbers
- How to provide an output based on a condition using IfElse()
- How to compare one value to multiple values and return results accordingly using Switch()
- How to convert text to upper case using Upper()
- 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 to format a number input using FormatNumber()
- 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 translate terms or sentences using Translate()
- How to join two pieces of text together using Concat()
- How to join multiple pieces of text with a separator using StringJoin()
- How to separate multiple pieces of text using StringSplit()
- How to use functions GreaterThan(), LessThan() and Equals() with number values
- How to generate a unique number using Ticks()
- 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 reverse the value of a True/False statement using Not()
- How to use the And() and Or() operators 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()
Help center