Expanding a Row

  • Updated

 

In Spreadsheet.com, expanding a row gives users another way to access and edit the data in worksheets. Transforming a row's data from a Sheet or Kanban view to a form, expanded rows allow users with sufficient permission the ability to edit and collaborate. Clicking on related rows also expands the row in the related workbook, allowing you to edit one worksheet from inside another.

Expand a row when you want to see all of that row's data in one place, access the cell and row messages, or easily make edits to attachments and related rows. For instance, in your Simple Spreadsheet.com CRM, expand a row to make edits to an opportunity, see what other users are saying about that opportunity, or investigate the full details for the related customer. 

How to Expand a Row

Users can expand each row to show all the data entered into the columns in that row as form fields that users can edit. Each expanded row also shows the row channel, which contains row and cell comments.

To expand a row, click on the expand icon in the row header. 

blobid0.png

You can also expand a row by double-clicking the row header or by right-clicking on the row header and selecting Expand row.

From the Kanban view, you can expand a row by clicking on the card.

Inside an Expanded Row

Expanding a row displays all of the cells in that row as a field in a form view. Expanding a row includes all cells, including ones that are not currently used. Based on your permission level, you can use the expanded row to edit cell values. 

Note: Even hidden columns are displayed in the expanded row.

blobid1.png

 

Row Number and Row Name are displayed at the top of the expanded row, with the row name coming from the designated primary column.

 

Each column is then shown as a separate Editable Form Field with a Data Type Indicator and the Column Name. Column names are set via the table header row.

 

Related rows columns are displayed as cards. You can open or edit a related row by clicking on the card, which will cause that card to be expanded as a form you can edit. You can even preview and edit rows residing in a different workbook.

 

Attachment columns are displayed as clickable thumbnails. You can add new attachments via the add attachment link or reorder attachments using the drag selector mceclip0.png next to the attachment's name. Also, rename and delete attachments via the Edit file name mceclip1.png and Remove file mceclip2.png icons that appear when you mouse over the attachment's name.  
 
Formulas columns are designated by a formula symbol next to their column name mceclip4.png and cannot be edited in an expanded row. Formula cells show the calculated result rather than the formula itself. For instance, below we have a formula column that uses the probability to show a trend icon, which is greyed out because it is inevitable:
mceclip3.png
In addition to Formula Columns, System Data Types (like the Autonumber, Created by, and Updated at data types, which are also called Column Only Data Types) are not editable, either in the usual worksheet view or by expanding a row.
 
Row Channel allows you to view and collaborate on cell and row-level comments (provided you have the necessary permissions). Use this space to @mention users to notify them of details in your worksheet, ask questions, or leave comments for others who view the worksheet.
 

Expanding_and_Editing.gif

More about the Row Channel and Comments

Workbooks have three levels of channels: the workbook channel, row channels, and cell channels.  Also called messages or comments, any user with sufficient permissions can leave a message in any of these three for other users to read. Comments in a row are designated by a yellow flag in the row header mceclip0.png, and cell messages are designated with a yellow flag in a cell mceclip1.png. When you expand a row, you will see both row and cell messages together in the Row Channel, sorted by when the latest comment was added. Responding to a cell message in an expanded row will add comments only to the row channel, not the cell channel. For complete details, see our articles on channels.

Expanding rows gives you access to several of Spreadsheet.com's unique features, including Related Rows and Row Channels. Check out the corresponding articles for those features or more unique row features like Row Hierarchies.