Best Of
Display all series in the legend for Pie & Donut Charts even when the value is 0
Currently the legends for Pie & Donut Charts will not display a series in the legend if the value is 0. All other chart types do, but Pie & Donut do not for some reason. This is really frustrating when creating dashboards, because if/when the value updates to a non-zero amount the series colors get all wonky & you have to go in to fix the dashboard. This should be fixed.
ro.fei
Reorder Favorites and Pinned Recents
It would be helpful if you could drag favorites and pinned recents to customize the order they appear in.
Re: October Question of the Month 💭 Join the conversation and receive a badge
A scary moment for me was while conducting a rock rescue training on how to rappell down an overhang, my seat harness started to break. At this point I was upside down of course with the ground about 100 feet below. Realizing I had to act quickly, I scrambled back up over the overhang as fast as I could until I was back above the overhang and no longer upside down.
As I was reflecting on the best way to salvage the situation and not completely lose face as the team leader, I realized this was an excellent opportunity to show my trainees how to respond to a situation when the rescuer was now in a position of being the rescuee. I showed them how to use a loop of webbing to construct a very basic climbing harness and then climbed upward and safely off the rock face.
All that before lunch! We all spent the remainder of the weekend safely practicing rescue situations with no more unexpected scary moments. At the end of the weekend, every trainee had successfully qualified for the team.
TomG
Re: Set a Min-Max for Axis on Charts
The dashboard charts should be more configurable. Two examples:
- I have a bar chart tracking several series' progress to 100% completion, however the chart axis goes all the way to 120%, even when I toggle on "scale to data values". 120% isn't possible in this case, and it looks very unprofessional.
- When I click on a chart, it should not only take me to the source chart, but to the specific line item. Often times we want to examine data on a more granular level, but the widget behavior only allows us to transport the view to the massive data set it is pulled from, giving no guidance as to where the data point they wanted to examine is.
These charts and metrics should be much more customizable.
Re: Dashboard Charts - Secondary Axis, additional data points, target line
Hi smartsheet. Please include combo graphs as a feature. We badly needed it.
Re: Row automation - add to top of sheet
Currently it seems there is no way to have new submissions move to the top of the page when being moved from one sheet to another.
For instance if I have 1 form that feeds into different Smartsheets via a workflow, it puts the new submission not only at the bottom of the list, but moves it down 4-5 rows.
Can there be a fix to have this flow to the top of the page for new submissions?
adam.b
Automatically assigning a row to a parent line once an intake form is filled
I would love it if there was a way for a row that is entered from an intake form to automatically categorize to a parent line and have the option to place it at the top or bottom of the children. For example, if I have a ticket request form and on the sheet there are 3 parents, Pending, New, and Closed requests. When someone fills in the ticket request form associated with the sheet, the new row would automatically categorize as a child row in the appropriate parent category. In this case New. Having to move manually and constantly move rows creates a lot of manual work. Perhaps a hidden auto-selection on the form settings or the form fields.
Re: Hot key for Expand and Collapse Row
Hi Smartsheet Product Group,
**STICKY REQUIRED PLEASE**
I've looked through your extensive hotkey list located at Keyboard shortcuts | Smartsheet Learning Center, and it's a great list tbh. I've found multiple threads (ideas/basic/discussions/support) asking the same question and not getting any traction.
See a list below dating all the way back to 2018 (including this area) only up to page 6 of searches:
• Hot key for Expand and Collapse Row — Smartsheet Community
• https://community.smartsheet.com/discussion/45441/collapse-and-expand
• https://community.smartsheet.com/discussion/77920/collapse-expand-rows
• https://community.smartsheet.com/discussion/50476/expand-collapse-rows
• https://community.smartsheet.com/discussion/94802/expand-or-collapse-items-within-a-heading-row-only
• Row Expansion with Hierarchy — Smartsheet Community
This is and probably will be an ongoing request that is a basic need for plans that are 100s if not 1000s of lines, and Excel/OpenOfficeSheets/GoogleSheets all have this function baked in or easily accessible through configuration.
Most people will probably created a new topic as you see above and not dive as deep as I am right now. I'm doing this based off annoyance for the most part, but also because I (being a large proponent of encouraging Smartsheet usage) I might leave the product itself eventually if this is not something being worked on.
What does this group of community driven folks need to do to get this feature added on your roadmap?
@Jeff Sieben @bsmith4 for visibility.
Option to duplicate a sheet and retain Change History
I would like to be able to create a copy of a sheet that retains the change history of the original sheet - most specifically/importantly, the Cell History.
Using Save as New... does not retain any change history.
