Sign in to join the conversation:
Hello, I would like to report the issues on my projects using a stacked area chart as per attached screenshot. Is there any way I can do this in Smartsheet? I am mainly talking about Dashboard functionality. Thank you!
Smartsheet does not have a stacked area chart type. They do have stacked bars (horizontal and vertical) though. I suggest that you Submit a Product enhancement Request, as that is definitely a great idea.
In the mean time, you could (sort of) replicate it using a line chart.
In your metrics sheet, the reds would be the count of the reds, the yellows would be the count of the yellows PLUS the reds, and your greens would be the count of greens PLUS yellows PLUS reds.
This would push each of the colors' numbers to the corresponding level of the graph.
Hi Paul, thank you so much, that's a good idea. I will definitely try this! I will also submit this as a product enhancement request. Thanks again!!
Happy to help!
Hi All, I’m looking for some guidance on how to best structure an activity plan in Smartsheet. I need to track and display: Date ranges for each activity Activity month Monthly budget Key points such as promos/offers Major events happening during the same period (e.g., national holidays, International Women’s Day, etc.)…
Greetings Smartsheet Wizards… I have created an automation that is supposed to only copy rows if a particular column is blank. The conditional block is set to "where column name is blank". However, the automation copies every row in the sheet, even the rows that contain text. Does the is blank condition not work correctly…
I've just added six sheet summary fields to a sheet. But I have to add the same six fields to another eight sheets. I've been looking in the posts here, and I don't see anyone addressing whether there's any way to copy/paste the
