How do I shorten the length of the text field in a metric widget?

Bill Brendle

I need to shorten these fields but can't seem to find how

Paul Newcome

Have you tried shortening the column width in the sheet?

Bill Brendle

Yes, I have. It appears that it auto adjust with the widget in the Dashboard.

I'm trying to take two columns, one with the name, the other with the data show side by side like below.

Paul Newcome

One option would be to use another column to join the two cells together on the data sheet and then reference this in your widget.

Bill Brendle

Thanks, I'm already using that workaround. I've also done it using summary fields.

I remember doing this in the past but I may have urban legend memory on that as it's been many sleep cycles ago.

I truly appreciate your time.

Paul Newcome

Are you able to provide a screenshot of your current data within the sheet that you are referencing?

Bill Brendle

The total for SUV and Truck are just a sum of the make in each. The makes are data input (my choice as they are not named the same in the master sheet) but the quantities are being pulled from a master sheet with this formula

=COUNTIFS({Vehicle Information Sheet Range 1}, CONTAINS("Dodge 5500", @cell))

Bill Brendle

I can get it to look like I want with

various work arounds for not being able to set the size of the text box.