Chart Widget -> Series tab not recognizing columns with a value of zero

Ben Donahue · 05/28/19

In the Chart Widget, under the Series tab, is there a way to get Smartsheet to recognize columns that currently have a value of zero?

I need to do this to lock in the colors of those columns, and you can't choose the color of the column when the value of that column happens to be zero.

Paul Newcome · 05/29/19

I put "dummy data" in consisting of random numbers, establish the colors, then revert my metrics back to the correct calculations.

Ben Donahue · 05/30/19

Yeah, that's the work-around. I was hoping for a more straight-forward solution.

Thank you, Paul.

Paul Newcome · 05/30/19

Unfortunately that's about it. Sorry I couldn't be of more help.

Andrée Starå · 05/30/19

Hi Ben,

Please submit an Enhancement Request when you have a moment.

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Chart Widget -> Series tab not recognizing columns with a value of zero

Comments

Categories