Is there a formula to pull each day's final numbers into a metrics sheet?

Kimberley O

I have created a tracking sheet for our supervisors to provide the number of transactions per category at the end of each day. I would like to roll this information into a dashboard for easy daily reporting to executive leadership but I'm having trouble with pulling only the day's information (from the most recent work day). For example, our daily report reads like this:

And I have a metrics sheet:

But I would only want the metrics from the most recent date (in the first example it would be for May 12). What would be the easiest way to collect only the most recent workday's numbers?

Paul McGuinness

Hi @Kimberley O

You could use a Index Match formula i.e.

Index({[Class D Auto Test]:[Class D Auto Test]},Match(Today(),{Date;Date},0))

You will need to adjust the ranges to reference the Daily Report Tracking Template but should do what you need.

Hope that helps

Thanks

Paul

Kimberley O

It worked perfectly! Thank you!!

Paul McGuinness

Hi @Kimberley O

You could use a Index Match formula i.e.

Index({[Class D Auto Test]:[Class D Auto Test]},Match(Today(),{Date;Date},0))

You will need to adjust the ranges to reference the Daily Report Tracking Template but should do what you need.

Hope that helps

Thanks

Paul

Kimberley O

It worked perfectly! Thank you!!