User guide
HomeContact support
  • reference
    • Start here
      • Quick find
    • Run your experiments
      • What is a block?
      • Slash commands
        • Markdown
        • Simple tables
        • Spreadsheets
        • Chemical reactions
        • DNA sequences
        • Molecules
        • Elements
        • Well plates
        • LaTeX
        • Fire diamonds
        • Code
        • Citations
        • File attachments
        • Images and videos
        • Callout block
        • Emoji
        • Adobe PDF
      • Metadata
        • Status
        • Assignee
        • Priority
        • Start and due dates
      • Dependencies
      • Templates
      • Version history
    • Share and collaborate
      • Share your work
      • Mention a labmate
      • Leave a comment
      • Witness & review
    • Never miss anything
      • My bench
      • Notifications
      • Bookmarks
      • Recently viewed
      • Calendar sync
    • Organize the lab
      • Organizations
      • Workspaces
      • Projects
      • Sub-experiments
      • Tags
    • Find and filter
      • Display options
      • Filters
      • Advanced search
      • Views
    • Customize your account
      • Profile details
      • Account security
      • Preferences
    • Integrate all your tools
      • Communication
        • Slack and Microsoft Teams
      • Code & computation
        • GitHub
        • Azure DevOps
        • Deepnote
      • ML & ETL pipelines
        • Seqera Nextflow Tower
        • TetraScience
      • File storage
        • Box
      • Visualization
        • Tableau
      • Equipment
        • Clustermarket
        • Sm@rtline Data Cockpit
      • Documentation
        • Protocols.io
      • Inventory
    • Analyze performance
      • Project analytics
      • PowerBI integration
    • Enterprise admin
      • Trust & compliance
      • SAML SSO
      • SCIM provisioning
      • RBAC & permissions
      • Audit log & SIEM streaming
      • Login restrictions
    • AI Copilot
      • Research progress
      • Assess risk
      • Planning
      • NLP search
  • Learn more
    • Contact support
    • Go to colabra.ai
Powered by GitBook
On this page
  • Video overview
  • Supported formulas

Was this helpful?

  1. reference
  2. Run your experiments
  3. Slash commands

Spreadsheets

PreviousSimple tablesNextChemical reactions

Last updated 2 years ago

Was this helpful?

Who can use this feature?

👤 By default, all (but not Viewers).

🏢 Available on the plan with the Spreadsheet add-on.

Type /Spreadsheet to insert a full-fledged Excel-compatible spreadsheet with support for all common Microsoft Excel and Google Sheets formulas, autofill, and up to 1,000,000 rows and columns.

Video overview

Supported formulas

Compatibility Functions

BETADIST, BETAINV, BINOMDIST, CHIDIST, CHIINV, CHITEST, CONFIDENCE, COVAR, CRITBINOM, EXPONDIST, FDIST, FLOOR, FTEST, GAMMADIST, GAMMAINV, HYPGEOMDIST, LOGINV, LOGNORMDIST, MODE, NEGBINOMDIST, NORM.INV, NORMDIST, NORMSDIST, NORMSINV, PERCENTILE, PERCENTRANK, POISSON, QUARTILE, RANK, STDEV, STDEVP, TDIST, TINV, TTEST, VAR, VARP, WEIBULL, ZTEST

Database Functions

DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP

Date and Time Functions

DATE, DATEDIF, DATEVALUE, DAY, DAYS, DAYS360, EDATE, EOMONTH, HOUR, ISOWEEKNUM, MINUTE, MONTH, NETWORKDAYS, NETWORKDAYS.INTL, NOW, SECOND, TIME, TIMEVALUE, TODAY, WEEKDAY, WEEKNUM, WORKDAY, WORKDAY.INTL, YEAR, YEARFRAC

Engineering Functions

BESSELI, BESSELJ, BESSELK, BESSELY, BIN2DEC, BIN2HEX, BIN2OCT, BITAND, BITLSHIFT, BITOR, BITRSHIFT, BITXOR, COMPLEX, CONVERT, DEC2BIN, DEC2HEX, DEC2OCT, DELTA, ERF, ERF.PRECISE, ERFC, ERFC.PRECISE, GESTEP, HEX2BIN, HEX2DEC, HEX2OCT, IMABS, IMAGINARY, IMARGUMENT, IMCONJUGATE, IMCOS, IMCOSH, IMCOT, IMCSC, IMCSCH, IMDIV, IMEXP, IMLN, IMLOG10, IMLOG2, IMPOWER, IMPRODUCT, IMREAL, IMSEC, IMSECH, IMSIN, IMSINH, IMSQRT, IMSUB, IMSUM, IMTAN, OCT2BIN, OCT2DEC, OCT2HEX

Financial Functions

ACCRINT, ACCRINTM, AMORDEGRC, AMORLINC, COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, CUMIPMT, CUMPRINC, DB, DDB, DISC, DOLLARDE, DOLLARFR, DURATION, EFFECT, FV, FVSCHEDULE, INTRATE, IPMT, IRR, ISPMT, MDURATION, MIRR, NOMINAL, NPER, NPV, ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD, PDURATION, PMT, PPMT, PRICE, PRICEDISC, PRICEMAT, PV, RATE, RECEIVED, RRI, SLN, SYD, TBILLEQ, TBILLPRICE, TBILLYIELD, VDB, XIRR, XNPV, YIELD, YIELDDISC, YIELDMAT

Information Functions

ERROR.TYPE, ISBLANK, ISERR, ISERROR, ISEVEN, ISFORMULA, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISREF, ISTEXT, N, NA, TYPE

Logical Functions

AND, FALSE, IF, IFERROR, IFNA, IFS, NOT, OR, SWITCH, TRUE, XOR

Lookup and Reference Functions

ADDRESS, AREAS, CHOOSE, COLUMN, COLUMNS, FILTER, FORMULATEXT, GETPIVOTDATA, HLOOKUP, HYPERLINK, INDEX, INDIRECT, LOOKUP, MATCH, OFFSET, ROW, ROWS, SINGLE, SORT, SORTBY, TRANSPOSE, UNIQUE, VLOOKUP, XLOOKUP, XMATCH

Math and Trigonometric Functions

ABS, ACOS, ACOSH, ACOT, ACOTH, AGGREGATE, ARABIC, ASIN, ASINH, ATAN, ATAN2, ATANH, BASE, CEILING, CEILING.MATH, CEILING.PRECISE, COMBIN, COMBINA, COS, COSH, COT, COTH, CSC, CSCH, DECIMAL, DEGREES, EVEN, EXACT, EXP, FACT, FACTDOUBLE, FLOOR.MATH, FLOOR.PRECISE, GCD, INT, ISO.CEILING, LCM, LET, LN, LOG, LOG10, MDETERM, MINVERSE, MMULT, MOD, MROUND, MULTINOMIAL, ODD, PI, POWER, PRODUCT, QUOTIENT, RADIANS, RAND, RANDARRAY, RANDBETWEEN, ROMAN, ROUND, ROUNDDOWN, ROUNDUP, SEC, SECH, SERIESSUM, SEQUENCE, SIGN, SIN, SINH, SQRT, SQRTPI, SUBTOTAL, SUM, SUMIF, SUMIFS, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2, SUMXMY2, TAN, TANH, TRUNC

Statistical Functions

AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, AVERAGEIFS, BETA.DIST, BETA.INV, BINOM.DIST, BINOM.DIST.RANGE, BINOM.INV, CHISQ.DIST, CHISQ.DIST.RT, CHISQ.INV, CHISQ.INV.RT, CHISQ.TEST, CONFIDENCE.NORM, CONFIDENCE.T, CORREL, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, COVARIANCE.P, COVARIANCE.S, DEVSQ, EXPON.DIST, F.DIST, F.DIST.RT, F.INV, F.INV.RT, F.TEST, FISHER, FINV, FISHERINV, FORECAST, FREQUENCY, GAMMA, GAMMA.DIST, GAMMA.INV, GAMMALN, GAMMALN.PRECISE, GAUSS, GEOMEAN, GROWTH, HARMEAN, HYPGEOM.DIST, INTERCEPT, KURT, LARGE, LINEST, LOGEST, LOGNORM.DIST, LOGNORM.INV, MAX, MAXA, MAXIFS, MEDIAN, MIN, MINA, MINIFS, MODE.MULT, MODE.SNGL, NEGBINOM.DIST, NORM.DIST, NORM.S.DIST, NORM.S.INV, NORMINV, PEARSON, PERCENTILE.EXC, PERCENTILE.INC, PERCENTRANK.EXC, PERCENTRANK.INC, PERMUT, PERMUTATIONA, PHI, POISSON.DIST, PROB, QUARTILE.EXC, QUARTILE.INC, RANK.AVG, RANK.EQ, RSQ, SKEW, SKEW.P, SLOPE, SMALL, STANDARDIZE, STDEVA, STDEV.P, STDEV.S, STDEVPA, STEYX, T.DIST, T.DIST.2T, T.DIST.RT, T.INV, T.INV.2T, T.TEST, TREND, TRIMMEAN, VARA, VAR.S, VAR.P, VARPA, WEIBULL.DIST, Z.TEST

Text Functions

BAHTTEXT, CHAR, CLEAN, CODE, CONCAT, CONCATENATE, DOLLAR, FIND, FINDB, FIXED, LEFT, LEFTB, LEN, LENB, LOWER, MID, MIDB, PROPER, REPLACE, REPLACEB, REPT, RIGHT, RIGHTB, SEARCH, SEARCHB, SUBSTITUTE, T, TEXT, TEXTJOIN, TRIM, UNICHAR, UNICODE, UPPER, VALUE

Web Functions

ENCODEURL, FILTERJSON, WEBSERVICE

Other Functions

EURO, EUROCONVERT, OBJECT, PROPERTY, REFRESH

The Spreadsheet block supports over 550 Excel formulas. For a full list and reference, visit .

SpreadJS Formula Functions
Admins and Editors
Enterprise