Okay, so apparently I'm not toooo old school to figure out. I asked ChatGPT and it gave me this. I'll print on one of my stone tables to use it in the future.
Sure! Airtable provides a wide range of formula functions that you can use to manipulate and analyze data within fields. Here's a comprehensive list of formula functions available in Airtable:
### **Mathematical Functions**
- `ABS(value)` - Absolute value.
- `CEILING(value)` - Rounds a number up to the nearest integer.
- `FLOOR(value)` - Rounds a number down to the nearest integer.
- `ROUND(value, [num_digits])` - Rounds a number to a specified number of digits.
- `EXP(value)` - Returns Euler's number e raised to the power of the specified value.
- `LN(value)` - Natural logarithm of a number.
- `LOG(value, [base])` - Logarithm of a number with a specified base.
- `POWER(base, exponent)` - Base raised to the power of exponent.
- `SQRT(value)` - Square root of a number.
- `RAND()` - Returns a random number between 0 and 1.
- `RANDBETWEEN(min, max)` - Returns a random integer between the specified minimum and maximum values.
### **Text Functions**
- `CONCATENATE(...strings)` - Joins multiple strings together.
- `LEFT(text, [num_chars])` - Returns the leftmost characters from a string.
- `RIGHT(text, [num_chars])` - Returns the rightmost characters from a string.
- `MID(text, start, [num_chars])` - Extracts a substring from a string.
- `UPPER(text)` - Converts text to uppercase.
- `LOWER(text)` - Converts text to lowercase.
- `PROPER(text)` - Capitalizes the first letter of each word in a string.
- `TRIM(text)` - Removes extra spaces from text.
- `FIND(search_text, text)` - Finds the position of a substring within a string.
- `REPLACE(text, start_num, num_chars, new_text)` - Replaces part of a string with another string.
- `SUBSTITUTE(text, old_text, new_text)` - Substitutes occurrences of a substring with a new substring.
- `LEN(text)` - Returns the length of a string.
### **Date and Time Functions**
- `DATEADD(date, amount, unit)` - Adds a specified amount of time to a date.
- `DATEDIFF(date1, date2, unit)` - Returns the difference between two dates in a specified unit.
- `DATETIME_FORMAT(date, format)` - Formats a date according to a specified format.
- `DATETIME_DIFF(date1, date2, unit)` - Returns the difference between two dates in a specified unit.
- `NOW()` - Returns the current date and time.
- `TODAY()` - Returns the current date.
- `DATESTR(date)` - Converts a date to a string.
- `TIMESTR(date)` - Converts a time to a string.
### **Logical Functions**
- `IF(condition, value_if_true, [value_if_false])` - Returns one value if a condition is true and another value if it is false.
- `AND(condition1, condition2, ...)` - Returns true if all conditions are true.
- `OR(condition1, condition2, ...)` - Returns true if any condition is true.
- `NOT(condition)` - Returns the opposite of a condition.
### **Aggregation Functions**
- `SUM(values)` - Adds up all the values.
- `AVG(values)` - Calculates the average of values.
- `MIN(values)` - Returns the smallest value.
- `MAX(values)` - Returns the largest value.
- `COUNT(values)` - Counts the number of values.
### **Lookup and Reference Functions**
- `ARRAYJOIN(array, delimiter)` - Joins an array of values into a single string separated by a delimiter.
- `ARRAYCOMPACT(array)` - Removes empty values from an array.
- `ARRAYUNIQUE(array)` - Returns an array with unique values.
### **Other Functions**
- `BLANK()` - Represents a blank or empty value.
- `ISERROR(value)` - Returns true if a value is an error.
- `ISBLANK(value)` - Returns true if a value is blank.
- `VALUE(text)` - Converts a text value to a number.
These functions can be combined in various ways to create powerful formulas tailored to your specific needs. If you have a particular use case or need further details on any function, feel free to ask!
Jeff Johnson
President, ChattLab Makerspace
