Formulas

Counts the size of a list

Output

Outputs the count of non-blank values in list(s).

Counts number of unique values

Output

Outputs a count of all of the unique value(s) ignoring duplicates and blank values. Counts each unique item in a value if it is a list.

Get the position of a value

Output

Outputs the first position of needle in haystack starting at startAt, or -1 if not found. Works with text and lists.

Get the row of a table with the maximum value in the provided column, or item in a list with the maximum value by the provided formula.

Output

Outputs the maximum item inlist based on evaluating compareBy over each item. This will return the item in the original list, not the value that is used for comparison - use Max(list.compareBy) instead to only fetch the maximum compared value.

Get the row of a table with the minimum value in the provided column, or item in a list with the minimum value by the provided formula.

Output

Outputs the minimum item in list based on evaluating compareBy over each item. This will return the item in the original list, not the value that is used for comparison - use Min(list.compareBy) instead to only fetch the minimum compared value.

Get part of a list or text

Output

Outputs a part of the provided value based on the start and end positions.

Sort a list or column

Output

Outputs dataset in sorted order. Sort order and criteria are specified by the ascending, sortBy and sortByCount inputs.

Remove and add to a list or text

Output

Outputs value with deleteCount values removed and insertValue(s) added at start position.

Get the created date/time for a row or other object

Output

Outputs the created date/time for object.

Get the user's current time zone

Output

Outputs the user's current time zone.

Create a date value

Output

Outputs the date of the provided year, month, and day.

Create a date time value

Output

Outputs the date of the provided year, month, day, hour, minute, and second.

Round a date/time

Output

Outputs dateOrTime rounded to the nearest unit.

Convert date to epoch

Output

Outputs date as an epoch time (the number of seconds since Jan 1st, 1970).

Get the day-of-month from a date/time

Output

Outputs the day of month of the given dateTime as a number.

Get the document's timezone

Output

Outputs the document's timezone.

Get the last day of a given month

Output

Outputs the date for the last day of the month of dateTime plus monthOffset.

Convert epoch time to date

Output

Outputs epochTime as a date.

Get the hour from a date/time

Output

Outputs the hour of the given dateOrTime as a number.

Get the week number of a date in the ISO week numbering system, where week 1 contains the first Thursday of the year and weeks start on Monday

Output

Outputs the week of dateTime as a number between 1 and 52.

Get the day-of-week of a date/time as a number in the ISO week numbering system, where Monday is 1.

Output

Outputs the day-of-week of dateTime as a number between 1 and 7.

Get the minute from a date/time

Output

Outputs the minute of the given dateOrTime as a number.

Get the modified date/time for a row or other object

Output

Outputs the modified date/time for object.

Get the month from a date

Output

Outputs the month of the given dateTime as a number.

Get the month name for a date

Output

Outputs the month name for given dateTime as text.

Count working days between dates. Customize working days in region and date settings.

Output

Outputs the count of working days between startDate and endDate excluding holidays. Customize working days in region and date settings.

Get the current date/time

Output

Outputs the current date and time. Updates based on precision specified.

Add months to a date/time

Output

Outputs months added to dateTime rounded to the day.

Get the "second" from a date/time

Output

Outputs the seconds part of the given dateOrTime as a number.

Create a time value

Output

Outputs the time of the provided hour, minute, and second.

Convert a time to a number

Output

Outputs time as a decimal ratio of the day.

Convert text into a date value. Respects the doc's date order setting.

Output

Outputs the value of text parsed into a date. Outputs blank if text can't be parsed.

Converts text into a date/time. Respects the doc's date order setting.

Output

Outputs the value of datetime parsed into a date and time. Outputs blank if datetimecan't be parsed.

Converts a value into a time

Output

Outputs the value of value parsed into a time. Outputs blank if valuecan't be parsed.

Get today's date

Output

Outputs the current date. Updates daily.

Get the week number of a date, where week 1 contains Jan 1. Respects the doc’s first day of week setting. Use "IsoWeekNumber()" if week 1 should contain the first Thursday of the year.

Output

Outputs the week of dateTime as a number between 1 and 52.

Get the day-of-week of a date/time as a number. Respects the doc’s first day of week setting.

Output

Outputs the day-of-week of dateTime as a number between 1 and 7.

Get the day-of-week of a date as text

Output

Outputs the day-of-week of dateTime as text ("Monday", "Tuesday", etc.).

Adds working days to a date. Customize working days in region and date settings.

Output

Outputs a date based on your startDate plus the numWorkingDays you wish to move forward skipping over any dates included in holidays.

Get the year of a date

Output

Outputs the year of the given dateTime as a number.

Create a time duration (for days)

Output

Outputs a time duration for the specified number of days.

Create a time duration

Output

Outputs a time duration for the specified number of days, hours, minutes, and seconds.

Create a time duration (for hours)

Output

Outputs a time duration for the specified number of hours.

Create a time duration (for minutes)

Output

Outputs a time duration for the specified number of minutes.

Create a time duration (for seconds)

Output

Outputs a time duration for the specified number of seconds.

Convert a time duration into a number of days

Output

Outputs a number of days for the specified duration.

Convert a time duration into a number of hours

Output

Outputs a number of hours for the specified duration.

Convert a time duration into a number of minutes

Output

Outputs a number of minutes for the specified duration.

Convert a time duration into a number of seconds

Output

Outputs a number of seconds for the specified duration.

Compute the average of a filtered list of numbers

Output

Outputs the average of a list of numbers for values matching expression. Blank values are ignored.

Get the count for a filtered list

Output

Outputs the count of values in list for values matching expression. Blank values are ignored.

Gets a list of values that match your filter

Output

Outputs a list of all values in list that match expression.

Check if a reference is from a table

Output

Outputs True if row is a row in table. Otherwise outputs False.

Get the rows from a table that match your filter

Output

Outputs the rows from a table where column is the same as match value. We recommend using Table.Filter() instead.

Checks if a Coda control matches a value

Output

Outputs True if the given value matches the control. Otherwise outputs False.

Compute the sum for a filtered list

Output

Outputs the sum of a list of numbers for values matching expression. Blank values are ignored.

Checks if a value is plain text or rich text

Output

Outputs True if the given value is plain text or rich text. Otherwise, outputs False.

Check if a value is blank

Output

Outputs True if the given value is blank. Otherwise, outputs False.

Checks if a value is a date

Output

Outputs True if the given value is a date. Otherwise, outputs False.

Checks if a value is true or false

Output

Outputs True if the given value is True or False. Outputs False if it's neither.

Checks if a value is not blank

Output

Outputs True if the given value is not blank. Otherwise, outputs False.

Checks if a value is not text

Output

Outputs True if the given value is not blank. Otherwise, outputs False.

Checks if a value is a number

Output

Outputs True if the given value is a number. Otherwise, outputs False.

Checks if a value is plain text

Output

Outputs True if the given value is plain text. Otherwise, outputs False. Will output False if value is rich text.

Checks if a value is rich text

Output

Outputs True if the given value is rich text. Otherwise, outputs False. Will output False if value is plain text.

Convert a value to a number

Output

Outputs value as a number if conversion with base is possible. Otherwise outputs value.

Convert a value to text

Output

Outputs value as text.

Checks if an expression evaluates to true for all values in a list

Output

Outputs True if the result for evaluating expression on every value in list is true.

Checks if an expression evaluates to true for any value in a list

Output

Outputs True if the result for evaluating expression on any value in list is true.

Checks if a list contains any value from a list

Output

Outputs True if any value in search exists in value.

Checks if a list contains all values from a list

Output

Outputs True if all values in search exists in value.

Checks if a list contains only values from a list

Output

Outputs True if only values in search exist in value.

Counts the size of a list including blank values

Output

Outputs the count of values in list, including blank values.

Get duplicate values

Output

Outputs a list of values which appear multiple times.

Get the first value from a list

Output

Outputs the first value in list or blank if the list is empty.

Run a formula for every item in a list

Output

Evaluates formula for every value in list and outputs a list of all formula outputs.

Run a formula for every item in a list

Output

Evaluates formula for every value in list and outputs a list of all formula outputs.

Checks if a value is in a list

Output

Outputs True if search is found in value.

Get the last value from a list

Output

Outputs the last value in list or blank if the list is empty.

Make a list of values

Output

Outputs a list of value(s) or an empty list if no value is provided.

Merge and flatten lists

Output

Outputs a list of all value(s). Nested lists are flattened in the output.

Returns the nth item in a list from the number provided

Output

Outputs the value from list at position. Results in an error if position is outside of list.

Select a random item from a list

Output

Outputs a random item from list. Regenerates on every edit by default.

Generate a random sample of items from a list

Output

Outputs a random sample of count items from list. By default, samples without replacement and regenerates on every edit.

Reverse the values in a list

Output

Returns list reversed.

Returns a list of numbers between the provided from and to parameters

Output

Outputs a list of numbers from start to end. Step size is controlled via the by input.

Deduplicate values

Output

Outputs a list of unique value(s). Deduplicates against each item in a value if it is a list.

Returns true if all the items are true, otherwise false

Output

Outputs True if all value(s) are true. Otherwise returns False.

Outputs false

Output

Outputs False.

Get a value conditionally (single condition)

Output

Outputs ifTrue if the condition is true. Otherwise outputs ifFalse.

Get a value with fallback if blank

Output

Outputs ifBlank if value is blank. Otherwise outputs value.

Negate a true or false value

Output

Outputs True if valueis false and False if value is true.

Check if any input is true

Output

Outputs True if any value is true. Otherwise outputs False.

Get a value conditionally. Handles multiple conditions

Output

Outputs the first result where value matches expression. Outputs an optional final value if no value matches.

Get a value conditionally. Handles multiple conditions with a fallback

Output

Outputs the first ifTrue value where condition is true. Outputs the an optional final value if no condition is true.

Outputs true

Output

Outputs true.

Get the absolute value of a number

Output

Outputs number without the sign, so negative numbers become positive in the output.

Averages a list of numbers ignoring any blank values

Output

Outputs the average value. Blank values are ignored. All items in value are averaged if value is a list.

Calculates the Binomial Coefficient

Output

Outputs the number of ways to choose k items out of n possibilities. In math, the symbols nCk and (n k) can denote a bionmial coefficient, and are sometimes read as "n choose k".

Rounds a number up to the nearest multiple

Output

Outputs value rounded up to the nearest multiple of factor.

Rounds a number up to the nearest even number

Output

Outputs value rounded up to the nearest even number.

Returns Euler's number e (~2.718) raised to a power

Output

Outputs Euler's number for value e (~2.718) raised to a power.

Calculates the product of an integer and all the integers below it

Output

Outputs the product of an integer value and all the integers below it. If the number if a decimal will only use the initial integer. Note: Inputs greater than 19 may cause precision errors.

Rounds a number down to the nearest multiple

Output

Outputs value rounded down to the nearest multiple of factor.

Checks if a value is even

Output

Outputs True if value is even. Otherwise returns False.

Checks if a value is odd

Output

Outputs True if value is odd. Otherwise returns False.

Get the natural logarithm of a number. (Base e)

Output

Outputs the logarithm of number, base e (Euler's number).

Get the logarithm of a number for a given base

Output

Outputs the logarithm of number to base.

Get the logarithm of a number (base 10)

Output

Get the logarithm of number (base 10).

Get the maximum number or date/time

Output

Outputs the maximum value. Blank values are ignored. Checks all items in value if value is a list. Use MaxBy instead to get the maximum value by a specific criteria.

Get the median number or date/time

Output

Outputs the median value. Blank values are ignored. Checks all items in value if value is a list.

Gets the minimum number or date/time

Output

Outputs the minimum value. Blank values are ignored. Checks all items in value if value is a list. Use MinBy instead to get the minimum value by a specific criteria.

Get the most common value

Output

Outputs the mode (most frequently occurring) value. Blank values are ignored. Checks all items in value if value is a list.

Rounds a number up to the nearest odd number

Output

Outputs value rounded up to the nearest odd number.

Get the value at a given percentile of a dataset

Output

Outputs the interpolated value at the given percentile within dataset.

Get percentile rank of a value in a dataset

Output

Outputs the percentile rank of value within dataset.

The mathematical π (pi) constant

Output

Outputs the mathematical π (pi) constant.

Calculates a number raised to a power

Output

Outputs number raised to exponent.

Multiplies numbers together

Output

Outputs the mathematical product of all values. Blank values are ignored. Multiplies all items in value if value is a list.

Divide one number by another

Output

Outputs dividend divided by divisor.

Generate a random number

Output

Outputs a random number between 0 and 1 (including 0, excluding 1). Regenerates on every edit by default.

Generate a random number between two values

Output

Outputs a random number between low and high.

Returns the ordered position of a value in a list

Output

Outputs the position of a value within dataset when sorted.

Gets the remainder from dividing two numbers

Output

Outputs the remainder when dividend is divided by divisor.

Round a number

Output

Outputs number rounded to the specific number of decimal places.

Round a number down

Output

Outputs number rounded down to the specified number of decimal places.

Rounds one number to the nearest integer multiple of another

Output

Outputs value rounded to the nearest multiple of factor. If no factor is specified rounds to the nearest integer.

Round a number up

Output

Outputs number rounded up to the specified number of decimal places.

Get the sign of a number

Output

Outputs -1 if number is negative, 0 if number is zero, or 1 if number is positive.

Calculates the square root of a number

Output

Outputs the square root of number.

Estimates the standard deviation of a population based on a sample of values

Output

Outputs the estimated standard deviation based on the sample in values. Blank values are ignored. All items in value are considered if value is a list.

Calculates the standard deviation based on an entire population

Output

Outputs the standard deviation based on values that make up the entire population. Blank values are ignored. All items in value are considered if value is a list.

Adds numbers together

Output

Outputs the mathematical sum of all values. Blank values are ignored. Sum all items in value if value is a list.

Calculates the total from multiplying two lists

Output

Outputs the total sum of the products of list1 and list2. Each list must be of equal size.

Truncates a number

Output

Outputs number truncated to places.

Gets the document ID from a Coda doc URL.

Output

Outputs the document ID from the given url.

Get the url for an object

Output

Outputs a URL for object.

Get the name of the page an object belongs to

Output

Outputs the name of the page that object belongs to.

Converts a CSV to list

Output

Outputs a list of items by parsing a csvString delimited by a delimiter. The delimiter can be changed to work with other formats like TSV. You can also use our CSV importer for one-off imports.

Updates a Coda doc URL to point to a new doc id.

Output

Outputs the updated URL.

Parses a JSON string

Output

Outputs the value parsed from jsonString at path. If path is not specified, outputs the entire parsed value.

Get the creator for a row or other object

Output

Outputs the user who created object.

Checks if the current user is logged in

Output

Outputs True if the current user is logged in. Otherwise, outputs False.

Returns the user who modified the previous item

Output

Outputs the user who modified object most recently.

Get the current logged in user

Output

Outputs the current user. Will be different for every user. Note: * User().email returns the current user emails * User().name returns the current users name *User().photo returns the current users photo *User().state returns the current users doc access (e.g. write access).

Names a value so you can refer to it inside an expression. Useful if you want to use a value multiple times (i.e., as a local variable) or give it a clearer name. If you have a nested formula with an inner and outer CurrentValue, you can give each of them distinct names

Output

Outputs the result of expression.

A unique ID for a row

Output

Outputs a unique ID for row.

Names a value so you can refer to it inside an expression. Useful if you want to use a value multiple times (i.e., as a local variable) or give it a clearer name. If you have a nested formula with an inner and outer CurrentValue, you can give each of them distinct names

Output

Outputs the result of expression.

Create a bulleted list of values

Output

Outputs a bulleted list of given value(s).

Change the relative indent of content

Output

Outputs text with indent adjusted by levels.

Create a numbered list of values

Output

Outputs a numbered list of given value(s).

Crops an image into a circle

Output

Outputs a cropped circular image.

Get an HTML embed for a URL

Output

Outputs an HTML embed for url with the specified width and height.

Create a link

Output

Outputs a link that shows the given displayValue and navigates to url.

Creates rich url card

Output

Outputs a card for the given url.

Gets an image for a URL

Output

Outputs an image for url with the specified width, height, name, style, and outline.

Generates a rectangle

Output

Outputs a rectangle with specified width, height, color, and name.

Returns the distance (in kilometers) between two locations (lat/long) on earth using the Haversine formula

Output

Outputs the distance in specified unit between location1 and location2 using the Haversine formula.

Get location for the provided lat-long

Output

Outputs a single location object using latitude and longitude. Can also optionally include altitude, heading, speed, accuracy, and altitudeAccuracy. Useful with Distance().

Create a unicode character (symbol)

Output

Outputs a single unicode character matching the charNumber given. https://en.wikipedia.org/wiki/List_of_Unicode_characters.

Combine multiple text values

Output

Outputs the combined text of all text values as a single text value.

Check if one text contains another.

Output

Outputs True if text contains searchText.

Decodes base64 encoded text

Output

Outputs base64Text as a string.

Encodes text as base64

Output

Outputs text base64 encoded.

Encodes text use in a URL

Output

Outputs text formatted so it can be used in the query string of a URL.

Check if text ends with a suffix

Output

Outputs True if text ends with suffix. Otherwise outputs False.

Substitute values into a text template

Output

Outputs text with all {X} values in template replaced with the matching text.

Combine multiple text values with a delimiter

Output

Outputs text combining all text(s) with delimiter in-between every item.

Extract starting characters from text

Output

Outputs the starting numberOfCharacters from text.

Pad text from the left

Output

Outputs text padded with padString at the start so that the resulting text has the given targetLength.

Returns length of the given text

Output

Outputs the number of characters in text.

Returns a line break

Output

Outputs a line break.

Convert text to lower case

Output

Outputs text with all characters made lower case.

Extract characters from the middle of text

Output

Outputs numberOfCharacters from text starting at position.

Return the parts of text that match a regular expression

Output

Outputs the portions of text that match regularExpression

Check if text matches a regular expression

Output

Outputs True if text matches regularExpression.

Substitute regular expression matches

Output

Outputs text with all regularExpression matches replaced with replacementText.

Repeats text multiple times

Output

Outputs text based on repeating text by the number of repetitions specified.

Replace a range within text

Output

Outputs text with numberOfCharacters removed starting at and replaced with replacementText.

Extract ending characters from text

Output

Outputs ending characters of text.

Pad text from the right

Output

Outputs text padded with padText at the end so that the resulting text has the given targetLength.

Split text on a delimiter

Output

Outputs a list generated from splitting text by the delimiter character.

Check if text starts with specified characters

Output

Outputs True if text starts with prefix. Otherwise outputs False.

Replace the first matching substring in some text

Output

Outputs text with the first searchFor match replaced with replacementText.

Replace all matching substrings in some text

Output

Outputs text with all searchFor matches replaced with replacementText.

Pretty-print a byte count (KB, MB, GB, etc.)

Output

Outputs a text rendering of byteCount (KB, MB, GB, etc.).

Convert a number to a hexadecimal string

Output

Outputs a text of decimalNumber converted to hexadecimal. Left-pads result with 0's to satisfy targetLength if specified.

Trim starting and ending spaces from text

Output

Outputs text with all of the leading and trailing spaces removed.

Convert text to upper case

Output

Outputs text with all characters made upper case.

Places the cursor on the given object

Output

Outputs an action which (when run) will place the cursor on object.

Modify matching rows or add one if none match

Output

Outputs an action which (when run) will modify all rows in table matching expression with specified columnValue(s). If no rows match, will add a new row.

Add a row to the table

Output

Outputs an action which (when run) will add a new row to table and update the specified column(s) with columnValue(s).

Copy a document to your document list

Output

Outputs an action which (when run) will copy this or another document.

Copies the current page to a new doc or to another doc

Output

An action which when triggered will copy the current page.

Copy content to your clipboard

Output

Outputs an action which (when run) will copy content to your clipboard. Rich text formatting will not be preserved.

Deletes specified rows

Output

Outputs an action which (when run) will delete each row in rows.

Duplicates a page

Output

Outputs an action (when run) which will create a duplicate page of page with the given name.

Duplicates one or more rows

Output

Outputs an action value which (when run) will duplicate the target rows and modify the specified column(s) with columnValue.

Modify values in one or more rows

Output

Outputs an action value which (when run) will modify the specified column(s) with columnValue(s) for each row in rows.

Does nothing.

Output

Outputs an action which (when run) does nothing.

Notify doc users

Output

Outputs an action which (when run) will send message to people via an email and in-app notification.

Opens the row

Output

Outputs an action which (when run) will open the row.

Open a link in a new tab

Output

Outputs an action which (when run) will open url in a new browser tab.

Refresh assistant related things

Output

Outputs an action which (when run) refreshes assistant data in references(s).

Refresh Pack columns

Output

Outputs an action which (when run) refreshes Pack data in column(s).

Refreshes the given Pack table. This is not supported in automations.

Output

Outputs an action which (when run) queues up a sync of the given table. Subsequent actions may complete before the sync starts, but syncs in the queue are processed sequentially.

Resets the value of a control

Output

Outputs an action value which (when run) will reset the value of control.

Run one or more actions

Output

Outputs an action which (when run) will run all provided action(s).

Set the value of a control

Output

Outputs an action value which (when run) will set the specified control with value.

Set the sync field setting for a sync table.

Open a dialog that prompts the user to sign up for Coda

Output

An action which when triggered will allow the user to sign up/sign in to Coda if they are not already signed in.