Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

- Airtable Community
- Discussions
- Ask A Question
- Formulas
- Is there a better reference for formula keywords?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Topic Labels:
Formulas

Solved

Jump to Solution

0
327
3

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sep 08, 2024 09:28 AM

Being new to airtable and not wanting to pollute the forums with silly questions I can look up myself, I've been trying to go to the online help to solve my own questions. Unless I'm missing it, most of what they provide is an organized set of articles which is to be frank, frustratingly useless to this old school gray haired developer. I was hoping to find a simple itemized list of terms with reference/example type information, almost like a dictionary. Every other programming language has this kind of thing, and you can easily find terms that sound like what you want with a quick description (reference style) and a few examples. Does this kind of thing exist, or is it just the article format? I know I can pay for teams and do the AI thing, or go ask chatgpt, but I'd rather just do it old school and research it quickly.

Thanks.

Jeff Johnson

President, ChattLab Makerspace

President, ChattLab Makerspace

Solved! Go to Solution.

2 Solutions

Accepted Solutions

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sep 08, 2024 09:47 AM

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

President, ChattLab Makerspace

Reply

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sep 08, 2024 11:23 AM

Several of those are not actual Airtable functions, and also the full list is much longer than that. This is the page you’re looking for:

https://support.airtable.com//docs/formula-field-reference

Hope this helps!

— ScottWorld, Expert Airtable Consultant

Reply

3 Replies 3

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sep 08, 2024 09:47 AM

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

President, ChattLab Makerspace

Reply

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sep 08, 2024 11:23 AM

Several of those are not actual Airtable functions, and also the full list is much longer than that. This is the page you’re looking for:

https://support.airtable.com//docs/formula-field-reference

Hope this helps!

— ScottWorld, Expert Airtable Consultant

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sep 08, 2024 03:40 PM

Thanks again, Scott!

Jeff Johnson

President, ChattLab Makerspace

President, ChattLab Makerspace

Reply