To insert a new table into a Notebook entry, click Insert and then choose Table from the drop down.

Use common table features

  • Formulas: Click on a cell, and type “=” to begin a formula. Reference other cells by clicking on other cells. Tip: You can create formulas that reference other tables 

  • Functions: Click on the fx symbol, and choose from the dropdown of functions. 

  • Merge cells: Select adjacent cells and click the Merge symbol to merge cells. Click again to unmerge the cells.

  • Scientific notation: For example, 1e3 will be interpreted as 1000 by the table. Change the precision by clicking the Settings gear and then Precision. 

  • Delete/insert rows and columns: Right-click on a row or column, and choose the appropriate action.

  • Rename tables: Right-click the table name, and then Rename Table.

Show your table formulas in your Benchling tables

If you want to show the formulas for your Benchling tables, click on the gear box on the top right of your entry. Select the box for "Show Formulas" to display the formulas you created. Simply unselect the box to turn it off!

Change the Format of Number

If you want numbering to be in Scientific Notation, prefix your formula with 0e0 + . For example,  =0e0 + (1 + A2)/A3 should render the value of (1 + A2)/A3 , but it forces it to be rendered in scientific notation.

If you want numbering to be in Decimal Form, prefix your formula with 0.0 + . For example,  =0.0 + (1 + A2)/A3 should render the value of (1 + A2)/A3 , but it forces it to be rendered in decimal form.

Change the Precision of Number

Precision setting can be found under the setting(gear icon) button in the table. You can use precision setting to define how many number of decimal places should exist for selected cells/columns/rows/table.

Fill Cells

Benchling's table can also auto-fill numerical series. To fill the series, you will need to add the subsequent number in another cell, highlight the cells, and drag the box from the blue-square (see gif below).

Use Selectors

With Selectors, set up data validation for specific cells to standardize data capture. 

Select one or more cells. Click the gear icon and choose Selector.

Click Create a new selector first.

Specify the Selector Name and the options for the selector, one per line. Click Save to create your new Selector

Click Back to return to the Set Selector screen. Your new selector will show up in the dropdown by default. If you create more than one selector, you can choose which one should apply to the cell(s) you picked earlier via the dropdown.

Click Set to apply the selector to the cell(s) you picked.

Now, Benchling will provide a dropdown menu of choices for that cell, and will indicate if the data entered in the cell is invalid via a red corner

Coercing Types

Within tables, you can use the following techniques:

=CONCATENATE(A1) to coerce a non-text value into text
=SUM(A1) to coerce a numeric-“valued” value into an actual number

Anchoring Cells

Anchoring, or locking a cell inside a formula, can be done by adding a $ between the letter and number of a cell, e.g. A$2, B$3.

Did this answer your question?