Worksheet - Row Grouping

Welcome to the Worksheet! The Worksheet is packed with capabilities so you can manage and organize your data more effectively than ever before. 

Row Grouping

Row Grouping allows you to cluster similar types of rows together to better organize your Worksheet.

When you group rows, it will turn all of the rows you select into child rows, and the parent row will be a new blank row that the children are grouped under. You can name the parent row anything you'd like.

To group rows together, select the checkboxes to the left of the items you want to group, then click the Group Rows icon that appears at the top of the screen.

 

 

After the rows are grouped together, the parent row has an expand and collapse caret on the left side of the cell, making it easy to expand and collapse the row group.

 

Add item(s) to an existing row group by clicking the six dots the the left of the item(s) and then dragging into the row group.

ezgif.com-video-to-gif.gif

Remove an item by following the same process and dragging out of the row group.

Note: The row group must be expanded in order to add or remove item(s) via this method.

 

Row Grouping makes the Worksheet cleaner and allows for flexibility in viewing only the content you want to see on the screen.

 

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments

2 comments
  • Suggest adding tips for adding and removing inventory to/from existing groups, by clicking the 6-dots to drag/drop the row.

    0
  • Is there an option to expand all groups/parents in a single click? When filtering formulations columns where the rows are grouped into categories(and minimised), those formulations require manually clicking each parent row to expand/reveal the actual formulation. A quick expand all function would help reduce clicks and open all parents showing the relevant raws used.

    0

Please sign in to leave a comment.