Trying to get a dashboard to update with the most current entry.

Dustin AK Lean VA

I am building a weight loss dashboard for a client, that they can use for their clients. Everything is working how I want it to except for the current weight. I am trying to get that to update based off of the most current weigh-in weight that is added via the form. In the picture below it should be 180. I am trying a bunch of different things but I am not having any luck getting it to work how I want to. I was most recently trying this with sheet summaries, but maybe there is an easier way. They submit there weigh-ins via a form that is linked on the dashboard.

Anson Cheung

Hi Dustin, Can you show us how did you derive the Current Weight and what is your formula at the back?

--Anson

Dustin AK Lean VA

There is no formula right now, the current weight is just what they will put in for the weeks entry on the weigh-in form. So whatever they put in for their weigh-in, I am trying to get to display for the current weight. Everything I have tried is not updating and just staying on what I set the first cell I set the Metric Widget to. So like here is one thing tried and did a summary but I originally set it to the weight 1 cell, but when a new row is added is then moves down to weight 2 cell. Staying on the 185 and not staying on the weight 1 cell.

sharkasits

@Dustin AK Lean VA You will need to have a calculation field.

If you add rows to the bottom:

=Index([Weigh-In]:[Weigh-In],COUNT([Weigh-In]:[Weigh-In]))

If you add rows to the top:

=Index([Weigh-In]:[Weigh-In],1)

Then you can point to the calculation field. Since it's pulling the latest number all the time, you don't need to worry about the row changing.

Dustin AK Lean VA

Thank you, I forgot all about using index!