Metric Widget - Multiple Cell Display

I am pulling data from multiple cells within a Project Sheet. The issue is that for each cell, the information is being presented differently. In some cells, the data is presented BELOW the Cell Title while in other cells, the data is presented NEXT TO the Cell Title. Is there a way to have the data presented the same for all cells being linked to a Metric Widget? All cells are formatted identical (Text/Number, Justified Left and Top, no text wrapping, Arial 10)

Metric Widget.jpg

Find more posts tagged with

Sheets

Reports

Project Management

Comments and Conversations

Comments

Andrée Starå

Hi Bryan,

This depends on how much information there is and how it fits in the widget.

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

Sasan

Bryan,

At this time, you may have to play around with the content (value) in the cells to make them close in # of characters (length). In some cases we are wrapping the value under the name and some case we are not. That's most likely due to value length. So that we can paint a good picture for future enhancement, would you be able to add a screen capture of your range selection in the sheet. We can then use the range and respective presentation as an example for enhancement.

Thanks

Sasan

Bryan Sampson

Sasan,

What you are saying is that the location of the data is dependent on the total amount of the data? Do you know what the cut off is?

Bryan Sampson

Unfortunately it does not. I am trying to format the Dashboard to be "pleasing" to the eye which means that I am trying to get the data formatted identical. The auto sizing of the widgets as well as this data "rule" is not making it easy.

I am still playing around with how to "correct" this, but it is a little frustrating. It is not a high priority issue at all, except to me. I do not want a client or an internal team distracted by anything during a meeting. So I try to make the formatting universal so that only the words change and their eyes are automatically brought to the "movement" of the change from widget to widget.

Sasan

Bryan,

Yes and there is no set cut off, as characters have different lengths. It's a matter of adding spaces or ...... or spaces and ' at the end to try to get it to close to a match on the content.

Sasan

sravya.gupta127326

Hi team, I have the same issue as Bryan - has there been any solution identified in the last 2 years for this? Thanks!

Sign in to join the conversation!

Quick Links

Trending discussions

Automation not working
I have a Smartsheet automation setup to reminder the planning to complete their sections. It is setup to remind weekly until completed box is checked. They received 2 reminders and then the reminders stopped. Any idea what could be wrong? I can't tell that anything has changed in the sheet. Thanks Freda
How to disable popups that obscure my formula?
I'm editing formulas in a Sheet Summary. However, I'm prevented from seeing the formula by an annoying "helpful" popup that obscures my view. I can't figure out how to get rid of the popup. Does anyone know?
Workflow Error: "Recipients: Edit workflow to fix recipients list"
I am trying to create a workflow and for some reason it gives me an error with the email I entered as the recipient for my Alert. It is an email that I know works, it is shared to the sheet, and the access to the sheet is unrestricted. I am perplexed at what the issue is. Anyone else get this and know what the issue is?