Smartsheet Basics

Smartsheet Basics

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

Dashboard Metrics

edited 07/31/24 in Smartsheet Basics

I'm looking to create a Metric Widget that pulls the newest data from one cell in one column that is submitted through a form. For example, we are creating a form where people can submit a bid for a car. I want to take the most current bid submitted and have that feed into a widget. I have the form set up so the data populates at the top of the form. Every time a person submits a bid it should populate in row 1, column titled Vehicle Bid. I want that information to flow into a metric widget on a dashboard. I am then going to use that widget to populate on our intranet so people can see the most recent bid made.

Answers

  • Community Champion

    Dashboard Metrics

    Hi,

    I hope you're well and safe!

    You can use the sheet summary and a formula to collect the latest entry and use it as the metric source.

    Would that work/help?

    I hope that helps!

    Be safe, and have a fantastic day!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Yes, I believe that would help. Would you be able to provide more information on the sheet summary and which formula to use?

Trending in Smartsheet Basics