Dashboard Metrics

asalcido

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.

Andrée Starå

https://community.smartsheet.com/discussion/128722/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!

asalcido

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