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

04/08/21
Answered - Pending Review

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

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Have you tried shortening the column width in the sheet?

  • Bill BrendleBill 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 NewcomePaul 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 BrendleBill 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 NewcomePaul Newcome ✭✭✭✭✭

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

  • Bill BrendleBill 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 BrendleBill 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.

Sign In or Register to comment.