Organizations can use over 100 kinds of formulas in the spreadsheet template that you upload for a Table field. For information on how to create and use a spreadsheet formula, we recommend using online resources such as Microsoft Excel's formulas overview.

The following Excel formulas are supported in Tables:

ABS
ACOS
ACOSH
ADDRESS
AND
ASIN
ASINH
ATAN
ATAN2
ATANH
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
CEILING
CHAR
CHOOSE
COLUMN
COLUMNS
CONCATENATE
COS
COSH
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
DATE
DATEVALUE
DAVERAGE
DAY
DAYS360
DCOUNT
DCOUNTA
DEGREES
DGET
DMAX
DMIN
DSUM
DVAR
DVARP
EDATE
EOMONTH
ERROR.TYPE
EXACT
EXP
FACT
FALSE
FIND
FIXED
FLOOR
HLOOKUP
HOUR
HYPERLINK
IF
IFERROR
IFNA
INDEX
INDIRECT
INT
ISBLANK
ISERR
ISERROR
ISEVEN
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD
ISOWEEKNUM
ISTEXT
LARGE
LEFT
LEN
LN
LOG
LOG10
LOOKUP
LOWER
MATCH
MAX
MAXA
MEDIAN
MID
MIN
MINA
MINUTE
MOD
MONTH
N
NA
NOT
NOW
OFFSET
OR
PI
POWER
PRODUCT
PROPER
QUOTIENT
RAND
RANDBETWEEN
RANK
RANK.AVG
RANK.EQ
REPLACE
REPT
RIGHT
ROUND
ROUNDDOWN
ROUNDUP
ROW
ROWS
SEARCH
SECOND
SIGN
SIN
SINH
SMALL
SQRT
SQRTPI
STDEV
STDEV.P
STDEV.S
STDEVP
SUBSTITUTE
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMPRODUCT
SUMSQ
T
TAN
TANH
TEXT
TIME
TIMEVALUE
TODAY
TRUE
TRUNC
UPPER
VALUE
VAR
VARP
VLOOKUP
WEEKDAY
WEEKNUM
WORKDAY
YEAR
YEARFRAC

Questions or interested in signing up for Tables? Email us at sales@submittable.com.

Did this answer your question?