Column Comments

Column comments are perfect tools to transform your data using JavaScript formulas. In the example below we will be converting usernames to lowercase in order to update these later with the Update from File feature in sapio365.

How to add Column comments

Click on any cell in any column. The comments column will be added on its right side. You can always move it after. Go to the Grid Actions tab → Add & Edit Comments → Add or Edit Column Comment.
(Optional) You have the option to switch to a temporary comment by clicking .
Enter the title for the new column.
(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
	Ctrl + W	See the calculated value of the applied formula on the first row of the selection.
	Ctrl + Insert	Select a reference column from the Show/Hide Columns grid.
	Ctrl + R	Select a value or formula that was previously used.
	Ctrl + F	Switch from text to formula.
	Ctrl + S	Switch from public (shared) to private comment .
		Select a cell background colour.

Switch to using a formula by clicking on to toggle to and type the following formula:
- CODE
```
('#userPrincipalName#').toUpperCase()
```
- The lookup reference is added by its column ID between # (in this example, #userPrincipalName#), or select it from the Show/Hide Columns grid that opens when you click on .
Click Apply.