Skip to main content
Skip table of contents

Cell Comments

Cell Comments can be used as sticky notes, but you can also use them as calculated columns using JavaScripts and reference columns.

cell-comments.jpg

How to add Cell comments

In the example and image below, a prefix "OLD_" is being added to the email.

  1. Click on a column (Email) and select the entries for which you wish to add the note or comment. The comments column will be added on its right side. You can always move it after.

  2. Go to the Grid Actions tab → Add & Edit Comments.

  3. (Optional) You have the option to switch to a temporary and a column comment by clicking button-make-temp.jpg and button-create-column-instead.jpg respectively.

  4. Enter the title for the new column.

  5. (Optional) See the table below for the various available options to use reference columns, use a formula, share comments and apply a colour.

Button

Shortcut

Descripton

button-eye.jpg

Ctrl + W

See the calculated value of the applied formula on the first row of the selection.

button-ref.jpg

Ctrl + Insert

Select a reference column from the Show/Hide Columns grid.

button-previous-comment.jpg

Ctrl + R

Select a value or formula that was previously used.

button-text.jpg

Ctrl + F

Switch from text to formulabutton-fx.jpg .

button-public.jpg

Ctrl + S

Switch from public (shared) to private commentbutton-private.jpg.

button-colour.jpg

Select a cell background colour.

  1. Enter a note or a formula. In this example:

    1. Type OLD_ and switch to using a formula by clicking on button-text.jpg to toggle to button-fx.jpg .

    2. Add a lookup reference by its column ID between # (in this example, #mail#), or select it from the Show/Hide Columns grid that opens when you click on button-ref.jpg .

  2. Click Apply.

create-cell-comments.jpg

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.