On the toolbar, select Group. Group your rows. Sort your groups in ascending or descending order. Add another group, if necessary. Optional: Control the default state of the groups when you load or refresh your report.
This is what my research found. For more information about plan types and included capabilities, see Smartsheet Features by Plan. With Grouping, you can combine similar values into groups, so rows can be organized into logical categories or classifications. You can add up to three groups per report.
How do I expand or collapse a group in Smartsheet?
To expand or collapse all rows, right-click the primary column. To expand the groups when you load a report, make sure it has fewer than 2,500 rows that meet the report criteria. Smartsheet automatically collapses groups, if your report has more than 2,500 rows.
One way to consider this is smartsheet has smart rows that allow you to build hierarchy, and easily organize, track, and move data. Rows also allow you to manage attachments and communication with your team, proof files, create custom documents, and set up reminders. To learn more about the power of rows, review the information in this learning topic.
Smartsheet automatically collapses groups, if your report has more than 2,500 rows. The primary column automatically moves to the far left when you group rows. If you print or export the report, you won’t see the group you set up. Only the rows will be visible in the file you printed or exported.
Why can’t I merge or split cells in Smartsheet?
Smartsheet is a Database Table with Project Management and Spreadsheet functionallity. Therefore A cell is a Field in that row in a databse table and that is why you cannot merge or split cells. Are you trying to physically merge the cells to get a bigger cell, or are you trying to merge the data into one cell?
, smart Sheet does not have the capability to merge cells. If you are trying to work in a title to a parent row, best option is to format row to not wrap text . There is no merge cells functionality in smartsheet.
How to merge data from two Excel spreadsheets?
Microsoft Query in Excel allows you to merge data through a connection to a SQL database. SUM formulas in Excel are similar to the INDIRECT function and VLOOKUP function to total data on multiple spreadsheets and then display it in a report.