Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Order of Metric Widget fields

✭✭✭✭✭
edited 01/22/24 in Smartsheet Basics

I am working with the metrics charts in the dashboard. I think it would be beneficial to be able to order the data in the order you wish for it to be displayed in. For instance in the screenshot I have provided you will see the data in the two charts have similar subtitles for the data however the data is displayed in different orders and it would be beneficial for reporting to upper management to have the data displayed in the same order...Total Number of Reports, Received by Deadline, Received After Deadline, Not Received...

image.png


Best Answer

  • Employee
    Answer ✓

    Hiya!

    Just jumping in here to clarify - this is currently possible! You can click-and-drag the order of fields in a Metric widget to configure it just how you'd like.

    For example if this is the order from my source sheet:

    Screenshot 2024-01-22 at 12.58.45.png

    I can then click-and-drag one of these fields to any other order:

    Screenshot 2024-01-22 at 12.59.12.png

    Let me know if this works for you @CaraBart28 or if you need any help.

    Cheers,

    Genevieve

    Need more information? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions

Answers

  • ✭✭✭✭

    @CaraBart28

    My work around for this is to put all my metrics for the Executive Dashboard(s) in a stand-alone metric sheet. That way, I can create formulas back to the source sheet and configure my rows and columns in a consistent manner without worrying about the supporting sheet.

    It's a little more work up front, but it gives you an amazing amount of flexibility and insight for the audience you need to reach.

    Cheers!

    Rose

  • Employee
    Answer ✓

    Hiya!

    Just jumping in here to clarify - this is currently possible! You can click-and-drag the order of fields in a Metric widget to configure it just how you'd like.

    For example if this is the order from my source sheet:

    Screenshot 2024-01-22 at 12.58.45.png

    I can then click-and-drag one of these fields to any other order:

    Screenshot 2024-01-22 at 12.59.12.png

    Let me know if this works for you @CaraBart28 or if you need any help.

    Cheers,

    Genevieve

    Need more information? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions

  • ✭✭✭✭✭
    edited 01/22/24

Trending in Smartsheet Basics