Marianne Martinez
Freezing columns and rows in Smartsheet is a highly requested feature, especially for users with large data sets. While Smartsheet does not currently support freezing rows, it does allow users to freeze columns. This means that the selected column and all columns to its left will remain visible while columns to the right can be scrolled through. However, there have been issues reported with this feature, such as frozen columns moving or disappearing when the browser size is adjusted. Users have suggested workarounds, such as setting the first row as the parent, which remains in place while child rows can be sorted. Smartsheet's team is considering ideas like freezing columns in Dynamic View, but it is not part of their short-term plan.
| Characteristics | Values |
|---|---|
| Freeze columns | Possible |
| Freeze rows | Not possible |
| Default column headers | Frozen and always visible when scrolling vertically |
| Freeze panes | Not possible |
| Workaround for freezing rows | Make the first row the parent |
Explore related products
What You'll Learn
Freezing columns in a standard sheet
To freeze a column in a standard sheet, start by hovering over the column header of the column you want to freeze. Then, select the Column Menu icon and choose "Freeze Column" from the menu. This will lock the selected column and any columns to its left in place, allowing you to scroll through the columns to its right while keeping the frozen columns visible.
It's important to note that Smartsheet automatically freezes column headers by default, ensuring they remain visible when scrolling vertically. This feature enhances the sheet's usability by providing a constant reference for the data in the columns.
While freezing columns in standard sheets is a valuable tool, some users have expressed a desire to have the same functionality extended to Dynamic View. Currently, freezing columns in Dynamic View is not possible, but Smartsheet is considering this enhancement. In the meantime, users can employ workarounds, such as using the first row as the parent row, to maintain visibility of important information while scrolling.
Overall, the ability to freeze columns in standard sheets improves the user experience by providing a way to keep crucial data in view at all times, facilitating easier navigation and analysis of information within the sheet.
Circulon Pans: Cleaning Tips for Removing Stubborn Dirt
You may want to see also
Explore related products
Freezing rows
As of 2021, Smartsheet does not support freezing rows. However, there is a workaround for this limitation. By setting the first row as the parent row, it will remain in place while sorting the child rows. This makes the first row the ideal candidate for totals or calculations.
While Smartsheet does not support freezing rows, it does allow users to freeze columns. This feature ensures that selected columns remain visible while scrolling to the right. By default, column headers are frozen and always visible when scrolling vertically.
The inability to freeze rows in Smartsheet has been a long-standing request from users, especially those with large data sets or project management spreadsheets. It is considered a fundamental feature in competing software such as MS and Google. While Smartsheet has acknowledged the idea, it is unclear if and when this feature will be implemented.
In the meantime, users have suggested making the first row the parent as a workaround to keep important information visible while scrolling. This solution provides flexibility and allows for calculations without disrupting the totals.
Growing Patty Pan Squash: How Large Do They Get?
You may want to see also
Explore related products
Issues with freeze panes
While Smartsheet does offer the option to freeze columns, it does not currently allow users to freeze rows or panes. This has been a feature request since 2015, as the inability to freeze rows can make it difficult to keep things organised while scrolling through project plans.
There are, however, some issues with freezing columns in Smartsheet. One problem is that the freeze point sometimes moves on its own, causing frozen columns to disappear from view. This can be frustrating and confusing for users, especially those with different screen sizes, resolutions, and zoom settings. Another issue is that the freeze function may not work properly when switching between different monitor resolutions or browser dimensions. In some cases, users have found that the only fix is to unfreeze and then refreeze the column each day.
To address these issues, users can try adjusting their display size, selecting fewer rows to freeze, or using alternatives such as sorting and filtering data to focus on specific sections of the sheet. Additionally, checking permissions and ensuring that all users have the necessary access rights to alter sheet settings can help troubleshoot any problems.
While Smartsheet does not currently offer the ability to freeze panes, users can work around this limitation by utilising the available features for freezing columns and rows, along with the suggested troubleshooting solutions, to improve their overall experience.
The Lodge Pans: Pure Cast Iron Cookware
You may want to see also
Explore related products
Freeze panes in dynamic view
While Smartsheet does allow users to freeze columns, this feature is currently unavailable in Dynamic View. This has been a long-standing issue for many users, who have expressed their desire to see the ability to freeze columns or rows in Dynamic View implemented.
In a standard Smartsheet, users can freeze a column by hovering over the column header and selecting the 'Freeze Column' option from the Column Menu. This keeps the selected column and all columns to its left locked in place while the columns to its right can be scrolled through. However, this functionality is not available in Dynamic View, where users lose the initial columns when scrolling to the right.
Some users have found a workaround for this issue by making the first row the parent row. This allows the parent row to remain in place while sorting only the child rows. While this method provides some flexibility, it does not address the core issue of being unable to freeze columns or rows in Dynamic View.
The Smartsheet team has acknowledged the request for this feature and is considering ideas to bring sheet behaviour, such as freezing columns, to Dynamic View. While there are no short-term plans to implement this feature, the team is exploring ways to make it a reality.
Dutch Oven, Roasting Pan: What's the Difference?
You may want to see also
Explore related products
![Aluminum Pans With Lids 9x13 [10 Sets] Aluminum Foil Pans Trays With Lids - Half Size Tin Foil Disposable Pans For Baking, Cake Serving Dishes, Roasting, Heating, Serving & Lining Steam-Table Trays](https://m.media-amazon.com/images/I/71nz+lYm5JL._AC_UL320_.jpg)
Workarounds for freezing rows
As of 2022, Smartsheet does not support freezing rows. However, there are a few workarounds and alternatives that you can use to achieve a similar result.
One workaround is to make the first row the parent row. When you sort the rows, only the child rows will be sorted, while the parent row will remain in place. This can be particularly useful if you want to use the first row as the TOTAL row. To do this, you will need to indent all other rows to make them child rows. You can then use formulas such as "=sum(children())" in the first row to total the child rows. This workaround allows you to sort your data without affecting the totals in the first row.
Another alternative is to use the freeze column feature in Smartsheet. While it doesn't freeze rows, this feature allows you to keep certain columns visible while scrolling through the columns to their right. By default, column headers are frozen and always visible when scrolling vertically. This can be helpful if you need to keep certain column information visible while working on the rest of the sheet.
While these workarounds may not directly freeze rows, they can provide temporary solutions until Smartsheet implements the freeze row functionality that many users have requested.
Heritage Rock Pans: Are They Toxic?
You may want to see also
Frequently asked questions
Yes, you can freeze panes in Smartsheet.
To freeze a column, hover over the column header, select the Column Menu icon, and choose 'Freeze Column' from the menu.
No, you cannot freeze rows in Smartsheet. However, you can make the first row the parent, so when you sort the rows, only the child rows are affected.
No, it is not possible to freeze columns in Dynamic View at the moment.
Some users have reported issues with frozen panes moving or being changed without user input, especially when multiple users access the sheet.
![PAMI Aluminum Food Containers With Lids Half Size, Deep [Pack of 25] - 9”x13” Oven & Freezer Safe Tin Food Trays- Aluminum Baking Pans With Lids For Grill, Roast, BBQ- To Go Foil Takeout Containers](https://m.media-amazon.com/images/I/71kz+7NFZuL._AC_UL320_.jpg)
