TableStudio Functions

Use this article as the main function index for TableStudio. It lists the formulas currently available and points to the detailed articles where those already exist. When you start a cell edit with =, TableStudio also opens a formula help pane beside the cell. That pane begins with this function index, then switches to the matching function as you type. It shows the function signature, an example, argument meaning, and a live preview result when that preview is safe to calculate.

Available functions

• SUM
• AVG
• MIN
• MAX
• IF / AND / OR
• ROUND / ROUNDUP / ROUNDDOWN
• CONVERT
• FINDROW
• TOBJ
• Date Formulas
• TRANSLATE
• LOCATION, COUNTRY, DISTANCE, POLYLINE, AREA

Aggregation and totals

• SUM: adds values, ranges, and cross-sheet ranges. On a WBS separator or parent row, the exact =SUM or =SUM() rolls up that WBS block in the same column.
• AVG(value1, value2, ...) or AVG(range): returns the average of numeric values.
• MIN(value1, value2, ...) or MIN(range): returns the smallest numeric value.
• MAX(value1, value2, ...) or MAX(range): returns the largest numeric value.

Logical functions

• IF / AND / OR:
• IF(condition, value_if_true[, value_if_false])
• AND(condition1, condition2, ...)
• OR(condition1, condition2, ...)
• Conditions support =, <>, !=, >, <, >=, and <=.

Rounding

• ROUND / ROUNDUP / ROUNDDOWN:
• ROUND(value[, decimals]) rounds to the nearest value
• ROUNDUP(value[, decimals]) and RUP(value[, decimals]) round away from 0
• ROUNDDOWN(value[, decimals]) and RDOWN(value[, decimals]) round toward 0

Unit and coordinate conversions

• CONVERT: CONVERT([what,] from, to, value) converts temperature, coordinates, length, and weight/mass values. Its key coordinate workflow is fast GPS/WGS84 <-> Romanian Stereo70 transformation.
• Temperature helpers accept C, F, K, and full names such as Celsius, Fahrenheit, and Kelvin.
• Coordinate helpers accept gps, wgs84, w84, stereo70, s70, EPSG:4326, EPSG:3844, and EPSG:31700. Use WGS84 as the correct GPS name; W84 is accepted as a forgiving alias. See Convert GPS and Stereo70 Coordinates in TableStudio for the step-by-step workflow.
• Length helpers include metric, imperial, and nautical units such as mm, cm, m, km, in, ft, yd, mi, and nmi.
• Weight helpers include mg, g, kg, t, tonne, oz, lb, and stone.

Lookup and row search

• FINDROW: FINDROW(value, column, sheet[, offsetOrColumn[, ifNotFound]]) searches a sheet column and returns either the found row number or a related value from the matched row.

Table objects

• TOBJ: embedded table-object formulas.
• TOBJ(code) opens the stored object and shows the code
• TOBJ(code, exportRef) shows an exported cell value from that object
• TOBJ(code, exportRef, cloneSourceCell) creates a new object by cloning another TOBJ on first open
• "CODE"(A1) reads the exported value from a stored TOBJ directly by code
• TOBJVALUE("CODE",A1) and TOBJVAL("CODE",A1) do the same thing in explicit function form
• Supported aliases: TOBJECT, TABLEOBJECT, TBLOBJECT

Date functions and date helpers

• Date Formulas:
• TODAY and TODAY() return the current date
• related helpers include M, MM, D, DD, YEAR, YYYY, YY, MONTH, DAY, and weekday counters from MONDAY(start,end) through SUNDAY(start,end)
• TODAY+N or TODAY-N shift the current date by days
• MM(date) / M(date) return the month as digits
• DD(date) / D(date) return the day as digits
• YYYY(date) / YY(date) / YEAR(date) return the year in numeric forms
• MONTH(date) returns the month name
• DAY(date) returns the day name
• MONDAY(start,end) through SUNDAY(start,end) count how many times that weekday appears between 2 dates
• If the date argument is omitted in single-date helpers, the current date is used.
• Weekday count helpers are inclusive of both the start and end dates.

Locations and maps

• LOCATION(place) stores a selected GeoNames place and shows only the place name in the cell. Example: =LOCATION("Madrid").
• LOCATION(latitude, longitude, level, name) stores a manual coordinate and shows name. Example: =LOCATION(40.4168,-3.7038,0,"Madrid manual"). If a cell contains a GPS coordinate pair, including a value returned by CONVERT(coord,s70,gps,...), use =LOCATION(A1, level, name).
• COUNTRY(country) accepts only country records. Example: =COUNTRY("Germany").
• DISTANCE(location1, location2[, location3, ...]) returns straight-line distance in kilometers between LOCATION cells.
• POLYLINE(location1, location2[, ...], name) creates a named map line from LOCATION cells or manual LOCATION values.
• AREA(location1, location2[, ...], name) creates a named map polygon from LOCATION cells or manual LOCATION values.
• GeoNames notice: data is from GeoNames under CC BY 4.0. WorkStudio indexes/converts it for search and maps, but does not guarantee geographic data accuracy, completeness, or suitability for critical use.

Formula templates by column

• Derived Formulas: column-level templates that use {row}, {this}, and DEFAULT to turn typed input into consistent formulas or codes.

AI translation

• TRANSLATE: TRANSLATE(text, source_language, target_language) translates a text value or cell using AI credits. Saved translations are reused when the source text and target language still match.

General formula notes

• Cross-sheet references such as SH2(A1) and scoped references such as WB:SH2(A1) can be used inside formulas.
• Absolute references with $ are supported in normal formulas and ranges.
• Empty cells used inside arithmetic behave as 0.
• TRANSLATE(...) is asynchronous: while a request is running the cell shows a translating status, then the saved result is reused.
• This index should be updated whenever a new TableStudio function is added.

Related: TableStudio, TableStudio Column Types, Column Type: Date, Lookup, TRANSLATE, Copyright.